#N/A Error Reference

S

Sergio

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...
 
J

Jacob Skaria

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
 
T

T. Valko

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same forumula returns both 0 & N/A 2
Vlookup doesn't work: results are wrong 2
Lookup functions always return n/a ??? 3
Formatting a spreadsheet to calculate difference in dates etc. 2
IF Function 3
Conditional sum, when condition has multiple values 3
Help with calculating time and a half - I've got straight time and double time. 4
IF #N/A ( in a range), "ALERT","OK" 7

Top