11 18:04:26 +0530
> *To: *Pravin Kumar; >
> *Subject: *Re: $$Excel-Macros$$
> VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)
>
> Dear Pravin,
>
> Please try it.
>
> =IFERROR(VLOOKUP(H17,[SCWK23134
> .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP
My friend I'll have data for all 34 35-53 soi there will be no error
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Date: Thu, 5 May 2011 18:04:26
To: Pravin Kumar;
Subject: Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)
Dear P
You can use Indirect Function for the same...
VLOOKUP(H17,indirect(SC231WK34.xls]Sheet1!")$I$5:$K$20,H$15,0)
On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar wrote:
>
> Folk
>
> I have different workbook with different name in different folder. the
> workbook name will be like SC231WK34, SC231WK35,
with INDIRECT
before.
Regards - Dave
Date: Thu, 5 May 2011 18:04:26 +0530
Subject: Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)
From: noorain.ans...@gmail.com
To: pravin.si...@gmail.com; excel-macros@googlegroups.com
Dear Pravin,
Please try it.
Dear Pravin,
Please try it.
=IFERROR(VLOOKUP(H17,[SCWK23134
.xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK35
.xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK36
.xls]Sheet1!$I$5:$K$20,H$15,0),"")))
On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar wrote:
>
Folk
I have different workbook with different name in different folder. the
workbook name will be like SC231WK34, SC231WK35, SC231WK36 etc. all the
sheet will be in the same format.
is there any way to write vlookup where I can link the part of the name to
any of cell.
VLOOKUP(H17,[SC231WK34.xls]