Hello, I am looking for an "If" formula that will perform the following - If a value in column A3:A30 is selected in cell D2 then return the associated value from column B to Cell D8.
Column A Column B
14.00% 0
15.00% 0
16.00% 0
17.00% 0
18.00% 0
19.00% 0
20.00% 0
21.00% 7
22.00% 7
23.00% 7
24.00% 10
25.00% 10
26.00% 10
27.00% 12
28.00% 12
29.00% 12
30.00% 15
31.00% 15
32.00% 15
33.00% 15
34.00% 15
35.00% 15
36.00% 15
37.00% 15
38.00% 15
39.00% 15
40.00% 15
41.00% 15
Cell D2 - 14.00%
Cell D8 - 0
Bookmarks