vlookup range true

[ntudev]

I'm trying to do a vlookup but the range needs to be true and not false.  I included an excel sheet with a vlookup on the 2nd tab for anyone that can help.

source

Level	Rank
1	1
3	2
4	3
4	4
5	5
7	6
9	7
12	8
16	9
23	10
33	11
54	12
74	13
141	14
254	15
608	16
993	17
1753	18
1753	19
3835	20
10000	21

target

Level
157.67
72.67
35.20
64.11
206.25
26.59
80.00
26.34
44.44
119.67
72.40
9.40
57.34
9.23
28.87
47.43
87.25
28.52
48.73

result should be like this

Level	rank
157.67	14
72.67	12
35.20	11
64.11	12
206.25	14
26.59	10
80.00	13
26.34	10
44.44	11
119.67	13
72.40	12
9.40	7
57.34	12
9.23	7
28.87	10
47.43	11
87.25	13
28.52	10
48.73	11

[Qiu]

@ntudev 
I prepared 2 possible approach.

The 2nd one should be faster for larger dataset considering the Appending is quite computational expensive.

[Felipe_Ribeir0]

Hi @ntudev 

Another way of doing this, but as @Qiu said if your dataset is much larger than this sample it is better to use his second option (that is not using the append tool)

[grazitti_sapna]

Hi @ntudev , Please find my solution attached. I would recommend the same solution to what @Qiu  and @Felipe_Ribeir0  has provided but if you want to go with second approach in case of large data set it would be a better approach.