Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a function to search a range for a number and...
then return the value of the cell next to that number to a given cell?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a function to search a range for a number and...
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a function to search a range for a number and...
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" wrote in message ... then return the value of the cell next to that number to a given cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a range variable inside a excel function | Excel Discussion (Misc queries) | |||
function problem regarding cell range | Excel Worksheet Functions | |||
Number range function | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
function cell range limitations | Excel Worksheet Functions |