ExcelBanter - How to look up a value?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to look up a value? (https://www.excelbanter.com/excel-discussion-misc-queries/136678-how-look-up-value.html)

Eric

How to look up a value?

There are 2 lists of value under Column A & B,
Does anyone have any suggestions on how to look up the largest value under
column B and return the value on the same row on column A.
Thank you for any suggestion
Eric

All times are GMT +1. The time now is 06:13 AM.