Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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... |
#2
|
|||
|
|||
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... |
#3
|
|||
|
|||
=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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|