I usually wait for the OP to post back, requesting a way to eliminate the
#N/A!
That way I have time to get up and fix another drink!
Where I am, it WAS SATURDAY EVENING !!!<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
Hi Ken!
Yes, I know ISERROR is the "catch-all".
Just wondering why you and RD didn't include an error trap
for the second lookup?
FALSE or 0? sheesh!
Wouldn't that be the same as:
=CONCATENATE(A1,B1) or =A1&B1
Biff
-----Original Message-----
Hi Biff - ISERROR is a very general error trap in a
VLOOKUP, and is usually
better served with ISNA which will trap just the specific
issue the OP wants
to cater for.
--
Regards
Ken....................... Microsoft MVP -
Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------
------------------
It's easier to beg forgiveness than ask
permission :-)
----------------------------------------------------------
------------------
"Biff" wrote in message
...
Hi!
Assume lookup value is in sheet1 A1.
The first lookup table is in sheet2 A1:B5.
The second lookup table is in sheet3 A1:B5.
=IF(ISERROR(VLOOKUP(A1,Sheet2!A1:B5,2,0)),IF(ISERR OR
(VLOOKUP(A1,Sheet3!A1:B5,2,0)),"",VLOOKUP(A1,Sheet 3!
A1:B5,2,0)),VLOOKUP(A1,Sheet2!A1:B5,2,0))
Biff
-----Original Message-----
I would like my vlookup function to look for a value in
one sheet and if it
doesn't find it, look in another sheet. Is this
possible?
I was considering using a nested if function but not
sure
how.
.
.
|