Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to create a spreadsheet for a colleague
I have the follwing numbers placed in Data!C4:L4 20 25 30 35 40 45 50 55 60 65 I use this formula MATCH(B3,Data!C4:L4,1) to return the column number. If the user enters anything between for instance 30 and 35 it returns 3 as it is supposed to. Unfortunately that is not what my colleague wants. He wants 30, 31, 32 to return 3 and 33, 34 and 35 to return 4. And same for other values of course. Is that possible at all using worksheetfunctions or do I have to create my own UDF? Jan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
MATCH problem | Excel Worksheet Functions | |||
Match function problem | Excel Worksheet Functions | |||
Index/Match problem | Excel Worksheet Functions | |||
Match Problem | Excel Discussion (Misc queries) | |||
match problem | Excel Worksheet Functions |