Hi,
If the matching data is only present in one or the other the 2 sheets, (ie,
not both) and if you are using FALSE (or 0) as your 4th argument in your
VLOOKUP's, you could try something like this:

IF(ISNA(VLOOKUP(1st Sheet Lookup Details),VLOOKUP(2nd Sheet Lookup
Details),VLOOKUP(1st Sheet Lookup details))

When using FALSE (or 0) as your 4th argument, VLOOKUP returns a #N/A when
its lookup value is not found.

Regards - Dave.

"gman1964" wrote:

I have a spreadsheet that has data in a column of cells that have both
numbers and letters (ABCD 123456) that shoud match data in one of two tabs in
the same worksheet. What I'm trying to do is have a forumla look at the
information in the first tab match it to the same matching information in the
other tabs and depending on which of the two tabs in finds the information in
will return a answer. I've been playing with the vlookup and can get a
formula to look at one sheet and return the right answer, but I can't get a
formula to look at both sheets and return the right answer.