You surprise me sir (not the lazy bit <vbg).

I always go for clarity over brevity <ebg

Bob


"Ken Wright" wrote in message
...
LOL - But I'm a lazy typist too and almost invariably use that syntax.
:-)

--
Regards
Ken.......................

"Bob Phillips" wrote in message
...
... and using 0 for the Range_lookup argument seems a bit perverse as
against FALSE.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ken Wright" wrote in 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.
.