View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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