Looking Up Only <""
Try
=VLOOKUP("*?",A1:D1000,4,FALSE)
Mike
"FARAZ QURESHI" wrote:
I have an Array of 4 columns A1:D1000.
First column consists of formulas which either result to a string or "".
How to insert a Vlookup() formula to checkout the Array and reflect the
value in corresponding 4th column where the Column A reflects the very first
piece of String?
In other words, a corrected version of a formula like:
=Vlookup(<"",A1:D1000,4,0)
--
Best Regards,
FARAZ A. QURESHI
|