MATCH problem
Perferct, thank you.
Jan
Eduardo wrote:
Hi,
try
=MATCH(CEILING(B3,4),C4:L4,1)
"Jan Kronsell" wrote:
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
.
|