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|
This question generated 13 answers. To proceed to the answers, click here.
This thread is current as of January 26, 2015.