Hello,
I am trying to add a filter to a vlookup, but not figuring it out.
My input is 5, which corresponds to both 50 and 150 in col B. Is there any way, if my filter input is b, my result will be 150?
Thanks a lot
I am trying to add a filter to a vlookup, but not figuring it out.
My input is 5, which corresponds to both 50 and 150 in col B. Is there any way, if my filter input is b, my result will be 150?
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 1 | 10 | a | ||||
2 | 2 | 20 | a | ||||
3 | 3 | 30 | a | ||||
4 | 4 | 40 | a | 5 | a | ||
5 | 5 | 50 | a | ||||
6 | 6 | 60 | a | ||||
7 | 7 | 70 | a | ||||
8 | 8 | 80 | a | 50 | |||
9 | 9 | 90 | a | ||||
10 | 10 | 100 | a | ||||
11 | 1 | 110 | b | ||||
12 | 2 | 120 | b | ||||
13 | 3 | 130 | b | ||||
14 | 4 | 140 | b | ||||
15 | 5 | 150 | b | ||||
16 | 6 | 160 | b | ||||
17 | 7 | 170 | b | ||||
18 | 8 | 180 | b | ||||
19 | 9 | 190 | b | ||||
20 | 10 | 200 | b | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D8 | D8 | =VLOOKUP(D4,A1:B20,2) |
Thanks a lot