Hi,

I'm sorry, but I just realised my response wasn't complete. You would have to be a mind reader to make this work. The formula is fine, but the cell reference of E2 (after MATCH) is one that I made up. So, in cell E2 I had a salary value I want to look up:

Code:

` =INDEX($A$2:$A$15,MATCH(E2,$B$2:$B$15,1))`

Just change that cell reference from E2 to whichever cell contains the salary value you wish to look up. Here's how my sample looks:

**Excel 2010**
| A | B | C | D | E | F |
---|

1 | Grade | Salary | | | Lookup Value | Grade |

2 | 335 | 15,588 | | | 15,705 | 338 |

3 | 336 | 15,625 | | | | |

4 | 337 | 15,663 | | | | |

5 | 338 | 15,700 | | | | |

6 | 339 | 15,738 | | | | |

7 | 340 | 15,775 | | | | |

8 | 341 | 15,813 | | | | |

9 | 342 | 15,850 | | | | |

10 | 343 | 15,888 | | | | |

11 | 344 | 15,925 | | | | |

12 | 345 | 15,963 | | | | |

13 | 346 | 16,000 | | | | |

14 | 347 | 16,038 | | | | |

15 | 348 | 16,075 | | | | |

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>

</thead><tbody>

</tbody>

**Sheet3**

**Worksheet Formulas**
Cell | Formula |
---|
F2 | =INDEX($A$2:$A$15,MATCH(E2,B2:B15,1)) |
---|
<thead>
</thead><tbody>
</tbody> |

<tbody>

</tbody>

As also mentioned, the VLOOKUP would work just fine as well if you can put the salary in the first column. With the salary you wish to lookup in cell E2 again, the VLOOKUP formula might be:

Code:

` =VLOOKUP(E2,$A$2:$A$15,2,TRUE)`

Using 'TRUE' in the VLOOKUP finds an approximate match rather than an exact match.

My apologies for any confusion ... it had been a long work day yesterday when I responded

Hope this helps.

Regards,

Scott