Dear Amir,
IFERROR will not work in excel 2003. Try this one
=IF(ISNA(IF(ISNA(VLOOKUP(B6,$E$3:$F$3,2,0)),VLOOKUP(B6,$H$3:$I$3,2,0),VLOOKUP(B6,$E$3:$F$3,2,0))),VLOOKUP(B6,$K$3:$L$3,2,0),"")
type the above formula anywhere in worksheet. cel (b6) is taken as lookup
value.
Thanks & Regards
Thamu
Thanks Dave nice idea.
Aamir Shahzad
On Wed, Jan 26, 2011 at 6:08 AM, Dave Bonallack
wrote:
> 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)))
>
> R
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 differen
