This one is giving me trouble. You have B:B and also A:A. I want to search
column C and return the value in column A that matches the seach in C. I got
it to return the same valu in the column I searched (C), but I can't get it
to return the value in A.

"Max" wrote:

Yes, of course, it'll work just as well with the more versatile INDEX/MATCH

An INDEX/MATCH example along the same lines as the earlier:
=IF(ISNA(MATCH(A1,Sheet1!B:B,0)),IF(ISNA(MATCH(A1, Sheet2!B:B,0)),"",INDEX(Sheet2!A:A,MATCH(A2,Sheet2 !B:B,0))),INDEX(Sheet1!A:A,MATCH(A2,Sheet1!B:B,0)) )

Above tries matching A1 in Sheet1's col B first, then IF no match is found,
it'll try in Sheet2's col B.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"thecdnmole" wrote in message
...
I have one column that is left of the balance of the vlookup colkumns and
used index to find the answer, can that be done similar to what you did
with
the vlookup on two sheets, but left side lookup?