Excel: Approximate Value Formula


Hi ALL, I hope someone can help me with this problem. What im trying to do it to look up the approximate value of Tab 1 column 1 from Tab 2 column 2. Below are the formula that i have used so far: =MATCH(MIN(ABS(Ratings!A:B-E9)),ABS(Ratings!A:B-E9),0) =VLOOKUP(E10,Ratings!C:D,2,TRUE) Both formula arent working. See tables below as in example Tab 1:

Actual NPS SC Value
33.33
50.48
17.01
0.00
Tab 2:
57.00 5
56.945 4.99
56.89 4.98
56.835 4.97
56.78 4.96
56.725 4.95
56.67 4.94
56.615 4.93


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of January 26, 2015.


For more resources for Microsoft Excel