then copy down:
>>
>>
>> =IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0)))
>>
>> Regards - Dave
>>
>> ------------------
>> Date: Tue, 25 Jan 2011 22:57:34 +0500
>> Subjec
P(B4,$K$3:$L$3,2,0)))
>
> Regards - Dave
>
> --
> Date: Tue, 25 Jan 2011 22:57:34 +0500
> Subject: $$Excel-Macros$$ Lookup values in different sheets
> From: aamirshahza...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hi experts,
&g
Hi,
IFERROR can be stacked, just like IF can be.
Try this formula in C4, then copy down:
=IFERROR(VLOOKUP(B4,$E$3:$F$3,2,0),IFERROR(VLOOKUP(B4,$H$3:$I$3,2,0),VLOOKUP(B4,$K$3:$L$3,2,0)))
Regards - Dave
Date: Tue, 25 Jan 2011 22:57:34 +0500
Subject: $$Excel-Macros$$ Lookup values in
Hi experts,
Can I find values in multiple sheets with vlookup function. sheet is
attached. iferror function can be use but it can helpful only with 2 sheet,
any guidance?
Regards,
Aamir Shahzad
--
--
Some important
