You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"steph" wrote in message
...
Yes, this worked perfectly--thanks very much!!
--
Thanks so much!


"T. Valko" wrote:

Try this:

=lIF(ISNA(VLOOKUP(P8,'[workbook2.xls]tabname'!$C:$S,17,0)),VLOOKUP(P8,'tabname
in workbook1'!$A:$F,5,0),VLOOKUP(P8,'[workbook2.xls]tabname'!$C:$S,17,0))


--
Biff
Microsoft Excel MVP



"steph" wrote in message
...
I have a new problem I need help with. I am trying to look up a value
found
in workbook #1. I need to lookup the value in workbook #2 and, if it's
not
found there, then lookup the value in a different tab of workbook #1.
Here
is what I have so far.

equalIF(ISNA(VLOOKUP(P8,'[workbook2.xls]tabname'!$C:$S,17,FALSE)),VLOOKUP(P8,'tabname
in workbook1'!$A:$F,5,FALSE))

The 2nd part of the formula works fine as the lookup returns the
appropriate
P8 value from the tab in workbook 1 when it is not found in workbook2.
However, when the value IS found in workbook2, it returns a value of
FALSE,
not the appropriate lookup value.

Should I be using a different IS function? Any assistance would be
greatly
appreciated!!
--
Thanks so much!