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