Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP help
I am trying to use vlookup in the new Excel 2007. Is there a way to write a
formula that would return a blank if the vlookup results to a "#N/A" and returns the vlookup value if there is a value to result. =IF(VLOOKUP($C115,insiteTracker,8,FALSE)="#N/A","",VLOOKUP($C115,insiteTracker,8,FALSE)) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP help
=IF(ISNA(your-vlookup-formula),"", your-vlookup-formula)
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ayo" wrote in message ... I am trying to use vlookup in the new Excel 2007. Is there a way to write a formula that would return a blank if the vlookup results to a "#N/A" and returns the vlookup value if there is a value to result. =IF(VLOOKUP($C115,insiteTracker,8,FALSE)="#N/A","",VLOOKUP($C115,insiteTracker,8,FALSE)) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP help
Thanks Bernard. Very Much.
"Bernard Liengme" wrote: =IF(ISNA(your-vlookup-formula),"", your-vlookup-formula) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ayo" wrote in message ... I am trying to use vlookup in the new Excel 2007. Is there a way to write a formula that would return a blank if the vlookup results to a "#N/A" and returns the vlookup value if there is a value to result. =IF(VLOOKUP($C115,insiteTracker,8,FALSE)="#N/A","",VLOOKUP($C115,insiteTracker,8,FALSE)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup problem - unable to get the vlookup property | Excel Programming | |||
using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming |