#NA as zero value
 

Hi.. Help needed urgently
In Sheet 1, i used VLOOKUP to find a specific GL code for value in Sheet 2.
Due to that GL code in Sheet 1 that i have specified was not reflected in
Sheet 2, the VLOOKUP formula generate an #NA. Is there any formula that can
change #NA to zero value. So that i can do my calculation and summation for
my Sheet 1.

Would appreciate for your kind assistance...

One way

=IF(ISNUMBER(MATCH(H1,A2:A50,0)),VLOOKUP(H1,A2:C50 ,3,0),0)

--
Regards,

Peo Sjoblom

(No private emails please)


"Janus Lee" <Janus wrote in message
...
Hi.. Help needed urgently
In Sheet 1, i used VLOOKUP to find a specific GL code for value in Sheet
2.
Due to that GL code in Sheet 1 that i have specified was not reflected in
Sheet 2, the VLOOKUP formula generate an #NA. Is there any formula that
can
change #NA to zero value. So that i can do my calculation and summation
for
my Sheet 1.

Would appreciate for your kind assistance...

=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula)

Vaya con Dios,
Chuck, CABGx3


"Janus Lee" <Janus wrote in message
...
Hi.. Help needed urgently
In Sheet 1, i used VLOOKUP to find a specific GL code for value in Sheet
2.
Due to that GL code in Sheet 1 that i have specified was not reflected in
Sheet 2, the VLOOKUP formula generate an #NA. Is there any formula that
can
change #NA to zero value. So that i can do my calculation and summation
for
my Sheet 1.

Would appreciate for your kind assistance...