VLOOKUP in 2 ranges

[Kelly]

I want to look up a value that appears on one pivot table
or another. I've tried the @if function and tried OR, but
nothing seems to work. Can I vlookup a value on two
different tables?
Thanks

 

[Matt Lunn]

Hi, I was just looking at this page - it may be helpful

http://www.cpearson.com/excel/duplicat.htm#ExtractingUniqu
e

See Extracting Values on One List and Not Another

Cheers

 

[Guest]

You could do an If statement with the VLOOKUP statement