Say the value to lookup is in D1 of Sheet1.
The formula is in Sheet1.

The datalist on Sheet1 is in A1 to C100.
The datalist on Sheet2 is in K1 to M50.

The list on Sheet1 has the return value in Column C,
The list on Sheet2 has the return value in Column L.

The datalist on Sheet1 has preference, meaning it will be the first list
searched, and if matches exist in both lists, the return will come from
Sheet1.

=IF(ISNA(MATCH(D1,A1:A100,0)),VLOOKUP(D1,SHEET2!K1 :M50,2,0),VLOOKUP(D1,A1:C1
00,3,0))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Try this in Sheet1:



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