Lookup value in col D when Col A & B are listed multiple times
I want to capture info from col C when values I enter equal values listed in
col A and col B (example - I enter 2.000 and 20-25 and it returns 1.550).
I have data as follows:
1.500 5-10 .896
1.500 15-20 .875
1.500 20-25 .866
2.000 15-20 1.750
2.000 20-25 1.550
3.500 15-20 2.420
3.500 20-25 2.300
3.500 25-30 2.260
3.500 35-40 2.140
Any suggestions? Thanks in advance.
|