Vlook ups

Hi Shereen,

Thank you for your question and welcome to the forum.

Please find attached the answer to the Vlookup exercise.

Thank you for your question.

I hope this answers your question.

Regards

Simon

Hi Shereen,

The file is on its way.

Here is the formula for cell B16:

=IF(ISBLANK(A16)," ",VLOOKUP(A16,'Product list'!$A$5:$F$44,3,FALSE))

The formula is saying if B16 is blank then leave a blank in the cell, otherwise if a product code is selected then lookup the relevant information in column 3 of the Product sheet.

I hope this answers your question.

Regards

Simon