I need help with a formula to return a value based on 2 criteria. I have a list of part numbers in coulmn A. My column D:I headers are 55, 56, 57, 58, 59, 60. Under each are a list of prices. So, each part number in column A has a different price under each column 55, 56, 57 , etc. So, the part number and all of it's prices are in the same row.
On another sheet I am listing a part number and need to return the price based on what I select from a drop down box......55, 56, 57, etc.
How can I do this?
On another sheet I am listing a part number and need to return the price based on what I select from a drop down box......55, 56, 57, etc.
How can I do this?