Vlookup problem in lookup range

V

viraj

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
 
M

Mike H

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
 
T

Toppers

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

Try setting to 0.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top