ExcelBanter - Getting corresponding test value to a MIN function

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Getting corresponding test value to a MIN function (https://www.excelbanter.com/excel-worksheet-functions/53374-getting-corresponding-test-value-min-function.html)

Willis in crisis

Getting corresponding test value to a MIN function

I have a sheet that looks something like this...

Car Price

Ferrari 120
Porsche 2435
Ford 270
Mazda 635

I am able to get one of the prices in another worksheet, by just selecting
the cell, but I want the name of the corresponding car to appear in the cell
at the right, and I dont know how to do it.

Help Please!!
Thanks,

John Michl

Getting corresponding test value to a MIN function

Can you be more specific. It's not clear to me what you are trying to
do.

All times are GMT +1. The time now is 04:11 AM.