Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
I have a VLOOKUP formula but it returns #N/A, this is because the value im
looking for does not exist in my table array. How can I change the fomula so if it returns #N/A, it is changed to 0. My Formula is: VLOOKUP($A5,'C:\Work\Tacho Infringements\[TDG EU.xls]9.4'!$1:$65536,26,FALSE) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
=IF(ISNA(VLOOKUP($A5,'C:\Work\Tacho Infringements\[TDG
EU.xls]9.4'!$1:$65536,26,FALSE)),"", VLOOKUP($A5,'C:\Work\Tacho Infringements\[TDG EU.xls]9.4'!$1:$65536,26,FALSE)) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "fluffymoore" wrote in message ... I have a VLOOKUP formula but it returns #N/A, this is because the value im looking for does not exist in my table array. How can I change the fomula so if it returns #N/A, it is changed to 0. My Formula is: VLOOKUP($A5,'C:\Work\Tacho Infringements\[TDG EU.xls]9.4'!$1:$65536,26,FALSE) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Help
=IF(ISNA(YourFormula),"",YourFormula)
-- Kind regards, Niek Otten Microsoft MVP - Excel "fluffymoore" wrote in message ... |I have a VLOOKUP formula but it returns #N/A, this is because the value im | looking for does not exist in my table array. How can I change the fomula so | if it returns #N/A, it is changed to 0. | | My Formula is: | | VLOOKUP($A5,'C:\Work\Tacho Infringements\[TDG EU.xls]9.4'!$1:$65536,26,FALSE) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |