Hello Forum,
I've spent the good part of an hour trying to find a solution to an excel problem and I've finally admitted defeat.
Can someone possibly help with a formula that looks up multiple criteria.
I have attached an example and would greatly appreciated someone pointing me in the right direction.
Note: The workbook has 2 worksheets 1)Results Sheet 2)Price Lookup
Thankyou in advance,
Paul...
In D4 Cell
=IFERROR(VLOOKUP(B4,'Price Lookup'!B5:K8,MATCH(C4,'Price Lookup'!B4:K4,0),0),"")
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
Thankyou very much Sixthsense - You're a champion.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks