Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking Up Only <""
Hi,
You have two different problems, your formula suggests what you want is: =IF(F9<"",VLOOKUP(F9,A1:D1000,4,0),"") But you discussion suggest a different issue: you want to look at the first character of the entries in column A only? =VLOOKUP(F9,A1:D1000,4,0) In that case you could enter the following in F9, the cell whose value I want to look up, A* This would find the first entry that has an A in the first position. Alternatively you could enter A in F9 and change the VLOOKUP to read =VLOOKUP(F9&"*",A1:D1000,4,0) If you are trying to trap the N/A error resulting from no match being found then =IF(ISNA(=VLOOKUP(F9&"*",A1:D1000,4,0)),"",=VLOOKU P(F9&"*",A1:D1000,4,0)) -- Thanks, Shane Devenshire "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |