View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
viraj viraj is offline
external usenet poster
 
Posts: 2
Default Vlookup problem in lookup range

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