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:
>
