Most valuable professional
  • Hot Topics

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 33.33 50.48 17.01 0 Tab 2: 57 56.945 56.89 56.835 56.78 56.725 56.67

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel