Multiple arrays

[Taka83]

Hi all,

Can someone please shed some light on a problem I am having. I am using the formula below to look up a value and return "finished" if there is a date in column 15, if not return "blank".

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

The problem is I need the formula to look at 4 separate arrays (4 tabs) for a specific (unique) value, how do I need to alter the formula to achieve this?

Thanks in advance,

Tak

 

[texasalynn]

take a look at this