A1 B1 C1 D1 E1 F1
100 32.5 2/1 2/6 101 x
100 33.4 2/4
100 34.5 2/5
100 31.6 2/6
100 34.9 2/9
101 38.4 2/1
101 34.4 2/4
101 39.7 2/5
101 39.1 2/6
101 31.1 2/9
102 32.4 2/1
102 34.1 2/4
102 33.3 2/5
102 34.9 2/6
102 31.1 2/9
What I am trying to do is create a formula that will let me enter in values into 2 cells and have it pull from a list. In the table above, I would like to enter data into cells D1 and E1, and have it pull the corresponding value from column B. For example, if cell D1 = 2/6 and E1 = 101, the value returned should be 39.1, displayed in cell F2. I can make it work if there is only one field that I am entering data into, but can't seem to do this with two criteria fields.
Bookmarks