View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default Looking Up Only <""

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