Vlookup single cell value across worksheets.

Hi, all.

I need to use a Vlookup for a single cell across all worksheet. What I want to do is enter a company name and see if it returns active or inactive. I created a client list on a blank worksheet with Vlookup but this was messing up the VBA search.

is there any way around this, please?

Many thanks in advance.

Jaime.

Hi Jaime,
Please try below formula. Only thing is that you need to use ranges from different sheet in your case. Make sure lookup value is not repeated in different ranges. In case if it is repeated it will return value for first search. Attachment has example.
Thank you.
"=IFERROR(VLOOKUP(B16,$I$11:$J$16,2,0),IFERROR(VLOOKUP(B16,$N$11:$O$16,2,0),0))"

Hi, there

Many thanks for that. And thank you so much for your swift response.

I'll give it a try.

Regards,

Jaime.