Hi

I am using the following statement to VLOOKUP a part from name range "look"

=IF(ISBLANK(A2),"",(VLOOKUP(A2,look,2,FALSE)))

I need to be able to lookup multiple ranges i.e. look2, look3

How do I modify the above statement to successfully look for "part A" in
look, look2 and look3?

Cheers