Vlookup returning Error

[stevewood313]

Hi All,

I wonder if anyone can help me, I have the following formula
=IF(O3="","",VLOOKUP(O3,Sheet3!E:F,2,FALSE))

I Need to add in the iserror to prevent returning an error but cant get it to work however I try it.

Any help would be greatly received

Many Thanks
Steve

[teylyn]

The formula looks fine. If O3 is empty, it will return a blank string. If it is not empty, the Vlookup will be performed.

What error do you get? If it's #N/A, then the value of O3 is not found in your lookup table.

Check for leading/trailing spaces. Check for numbers stored as text.

If that does not help, please upload a file with some sample data that mirrors your data layout and shows the same problem.

[stevewood313]

Hi Teylyn,

Many thanks for quick response, I do get the #n/a error, I believe this is because the data may not be in my vlookup list, I was wondering if it is possible to get this formula to return a "0" instead of #n/a.

Many Thanks

Steve

[teylyn]

returning a 0 instead of #N/A is possible, but not advisable. N/A is an error that shows you that your lookup value is not found in the lookup table, and you may want to capture that.

If you insist on exchanging N/A for 0, then you can use

=IF(O3="","",if(isna(match(O3,Sheet3!E:F,0)),0,VLOOKUP(O3,Sheet3!E:F,2,FALSE)))