Good day.
I am new with excel and would really appreciate your help.
I have to make a formula that looks up a price from 3 different price columns on sheet "Price list" (depending on type of client) and the product selected form a dropdown list in "ITEM" column on sheet "Cover". Each client has a different price depending on what type of client they are.
Please see the workbook attached.
Bookmarks