That works!!! Thank you so much. That has been bugging me for a long time!!
i am so glad I asked.

"Bernie Deitrick" wrote:

Julie,

Sorry, I was thinking of VLOOKUP and HLOOKUP.

Instead of LOOKUP, you need to use a combination of MATCH and INDEX:

=INDEX(Sheet2!F:F,MATCH(P:P,Sheet2!O:O,FALSE))

HTH,
Bernie
MS Excel MVP

"Julieeeee" wrote in message
...
How? It tells me "too many parameters" if I add a ,FALSE at then end

"Bernie Deitrick" wrote:

Julie,

Use False as the fourth parameter in your LOOKUP function, to force an exact match.

HTH,
Bernie
MS Excel MVP


"Julieeeee" wrote in message
...
Sheet1 has a list of confirmations but no reservation#. Sheet2 has some of
the same info, but not all confirmations have res#s. I want to see if the
conf# in sheet1 has a corresponding res# in sheet2. The formulas I am using
is
=LOOKUP(P:P,sheet2!O:O,sheet2!F:F)
where the conf# are in column P in sheet1 and in column O on sheet2, and the
res# is in column F on sheet2.
The results are giving me res# that don't correspond to the correct conf#.
Since not all conf#s have res#s, there should ne "N/A"s but there aren't any.
What am I doing wrong??
Thanks!
Julie