Question: I have a column (A1:A10) of people's names and a column (B1:B10) of numbers. I want to put into cell C1 a function that will locate the cell in B1:B10 that contains the smallest number and then display the person’s name in A1:A10 that is located just to the left of that number. Any help would be appreciated.
Bookmarks