ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Vlookup/Index/Match (https://www.excelbanter.com/excel-worksheet-functions/267895-vlookup-index-match.html)

frankjh19701

Vlookup/Index/Match
 
What I want to do is lookup the three highest values in a column and return the value in the adjacent cells into other cells.

For example:
Column A B C D
1 2.02% Matching value in Column A 1st Highest Value from B
2 1.80% Matching value in Column A 2nd Highest Value from B
3 2.04%
And So on

The values are in percentages that I need to find the three highest of.
The values are in numerics that I need to match to the percentages.

Any/all assistance is greatly appreciated.

Thank you


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com