With range_lookup=1, data in column C must be in ascending order.

Try setting to 0.

"viraj" wrote:

i tried to lookup some values but i am getting problems in particular No.

In B1 if i type 23 in B2 it has to lookup value from table and give result
as 12 but its not getting that value this problem is only for 23, 33, 73 for
other values its picking up correct nos. why this is happening and how to
solve the problem.

A B C D
1 C 23 27 15
2 G #VALUE! 23 12
3 38 20
4 33 20
5 53 30
6 46 25
7 68 35
8 59 30
9 85 45
10 73 40

Function Arguments in B2
Lookup_value B1
Table_array C1:D10
Col_index_num 2
Range_lookup 1


Regards

Rajesh