If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Replace #N/A with 0
When I use the vLookup formula and the result is #N/A, I need to replace this
with a 0, is this possible in only one formula? Thanks in advance Regards Emece.- |
#2
|
|||
|
|||
Replace #N/A with 0
Something like:
=IF(ISNA(VLOOKUP(A1,B1:B2,2)),0,VLOOKUP(A1,B1:B2,2 )) -- Gary''s Student - gsnu201001 "Emece" wrote: When I use the vLookup formula and the result is #N/A, I need to replace this with a 0, is this possible in only one formula? Thanks in advance Regards Emece.- |
Thread Tools | |
Display Modes | |
|
|