How do I create a function to search a range for a number and...

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Lookup returning wrong results 0
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
How do I have a cell value define a dynamic named range? 15
Search for specific text within last non blank cell in a range 2
SUM ONLY NUMBERS IN A RANGE 1
Excel Trying to code an Array Function in VBA Excel to works as a MaxIF 3

Back
Top