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

Hi,

If it only happens with certain numbers then it may well be a data type
error. I assume 23 should be a number so delete it format the cell as general
and put 23 back in it to see if it works. If it does then check other cells.

Mike

"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

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