IF OR Vlookup (Vlookup against multiple sheets)

Hi,

In Master tab, I have list in column A which is all values from sheet 1a and sheet1b.

I want to compare this against sheets1a and 1b, basically, compare against both sheets and if value is in either or, then display corresponding vol colume, else blank.

I think this is if (or (vloookup)?

Thanks for youre help in advance.

Hi,

Yes, this is a job for VLOOKUP.

Give this a try:

Please Login or Register  to view this content.

Hope this is helpful.

Cheers

Thank You Southward. Appreciate it. Works great!

Glad I could be of some assistance.

Cheers