VLOOKUP Help

F

fluffymoore

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)
 
B

Bob Phillips

=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 said:
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
Click to expand...
EU.xls]9.4'!$1:$65536,26,FALSE)
 
N

Niek Otten

=IF(ISNA(YourFormula),"",YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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)
 
Top