Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How not to show #N/A when using vlookup formula
I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have
inputed. Many of the responses come back with #N/A. I would like to remove this. Using IF(V3="","", does not work, becasue there is data there. What do I need to add to my formula? -- Thanks in advance, inthestand |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on a cell with a formula | Excel Worksheet Functions | |||
What can I add to a vlookup formula to give me a 0 not #n/a | Excel Worksheet Functions | |||
how to show formula in formula bar | New Users to Excel | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |