kesanakurthybvn
New Member
- Joined
- Nov 3, 2005
- Messages
- 2
Hi,
I have a column of numbers ranging from 0.1 to 1.0.I need to use a function such that it returns the address of the number in the column which is next highest to 0.5.like if i have 0.6,0.49.0.54,0.63.It needs to reurn 0.54.but when i used vlookup it returns the number nearest to 0.5 i.e. 0.49 but not 0.54. and i should be able to do that for any range of numbers.
Please help me.
Thanx.
I have a column of numbers ranging from 0.1 to 1.0.I need to use a function such that it returns the address of the number in the column which is next highest to 0.5.like if i have 0.6,0.49.0.54,0.63.It needs to reurn 0.54.but when i used vlookup it returns the number nearest to 0.5 i.e. 0.49 but not 0.54. and i should be able to do that for any range of numbers.
Please help me.
Thanx.