Vlookups with If

Hello Luke,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding using VLOOKUP and IF functions in the same formula.

The exercise activity in unit 2 uses an IF function to work with blank cells. If you enter a VLOOKUP function into a cell that refers to a blank cell then you will get an #N/A error. To remove the error all you have to do is add an IF statement which examines a cell to see if it is blank ("") then returns a blank value (""). At first the formula which produces the #N/A error would look like the following:

=VLOOKUP(A16,Product_list,3,FALSE)

After adding the IF function the formula would look like this:

=IF(A16="","",VLOOKUP(A16,Product_list,3,FALSE))

Give it a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer