Hi,

I'm using a Vlookup into another worksheet with the following function:


=IF(T42="","",VLOOKUP(T42,'Tracking'!B:F,5,FALSE))

In the look up cell, there is no data or the cell is (intentionally) blank.

I was thinking I can use something like this, which works if looking at the specific cell, H2302:

=IF(T42="","",IF('Tracking'!H2302="","",VLOOKUP(T42,'Issue Tracking'!B:H,7,FALSE)))

However, I do not want "lock onto" this cell because T42 cell data will constantly change.


How can modify this Vlookup function to give a blank result if the look up cell is also blank?


Thanks