Forum Discussion
How to LookUp a Value based on 1 drop down and 1 criteria from a different worksheet with 2 columns
I am trying to find the correct formula with the following details: On Sheet 1, I want to find what the price should be, based on 2 things: 1. Sheet 1 - A drop down with 2 options ("Roanoke"...
Use Index and Match Functions:
=IFERROR(INDEX(Sheet2!T2:U6,MATCH(D21,Sheet2!B2:B6,0),MATCH(D29,Sheet2!T1:U1,0)),"NoPrice")
FikturFox - Unfortunately, this did not work.
D29 is a text, not a number so I'm wondering if that's the issue?