then return the value of the cell next to that number to a given cell?
then return the value of the cell next to that number to a given cell?
With limited information, here is an example you can adjust:
Put some text in A1 to F1
Put some numbers in A2 to F2
Then in a cell somewhere put:
=INDEX($A$1:$F$1,MATCH(LARGE(A2:F2,2),A2:F2,))
This will look for the second largest number from row 2 and return the
adjacent text from row 1.
HTH
GerryK
"NECCExcel" wrote:
> then return the value of the cell next to that number to a given cell?
You can use the VLOOKUP function to do this. See help for more
details.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"NECCExcel" <[email protected]> wrote in
message
news:[email protected]...
> then return the value of the cell next to that number to a
> given cell?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks