VLOOKUP - Multiple arrays

[Taka83]

Hi all,

I need some assistance with the above. My current formula is as follows, and is fine for looking at a single array and returning "Finished" if there is a date and "blank" if not.

IF(ISNUMBER(VLOOKUP( )),"Finished","")

My question is, how do I get VLOOKUP to look through multiple arrays (4 different tabs) and return the same results as above. Each reference the VLOOKUP is searching for is unique, so it will only occur once over the different arrays.

Thanks in advance,

Tak

 

[anandvarma]

you have intelligently name the ranges in the vlookup

 

[Taka83]

Have I named the ranges, No.

If I do that, what next?

 

[Taka83]

Bump.

Sorry I'm stuck

 

[Taka83]

Can anyone help me with this please.