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.
In H21 Cell of Cover Sheet
=IFERROR(VLOOKUP($B21,'Price list'!$B$2:$G$95,MATCH(VLOOKUP($C$11,Contacts!$B:$C,2,FALSE),'Price list'!$B$1:$G$1,0),FALSE),"")
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you so much for your time. I will try this after work.
Have a wonderful day.
Oh thank you so so much. You are a star!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks