#N/A Error Reference
 

I currently have a look up table and use the following formula:

=VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,FALSE)

However, if any of the attributes in columns C D and E do not match, then
#N/A is returned (in this case Cell G2). This is causing a problem when I try
to total colum G. Is there a way of returning 0 instead of #N/A? I hope this
makes sense...

#N/A Error Reference
 

Handle that using ISNA() ...

=IF(ISNA(VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8, 0)),0,
VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,0))

If this post helps click Yes
---------------
Jacob Skaria


"Sergio" wrote:

I currently have a look up table and use the following formula:

=VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,FALSE)

However, if any of the attributes in columns C D and E do not match, then
#N/A is returned (in this case Cell G2). This is causing a problem when I try
to total colum G. Is there a way of returning 0 instead of #N/A? I hope this
makes sense...

#N/A Error Reference
 

One way...

=IF(COUNTIF(All_Prices!A$2:A$33,C2&D2&E2),VLOOKUP( C2&D2&E2,All_Prices!A$2:H$33,8,0),0)

--
Biff
Microsoft Excel MVP


"Sergio" wrote in message
...
I currently have a look up table and use the following formula:

=VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,FALSE)

However, if any of the attributes in columns C D and E do not match, then
#N/A is returned (in this case Cell G2). This is causing a problem when I
try
to total colum G. Is there a way of returning 0 instead of #N/A? I hope
this
makes sense...