vinod_siwan123
New Member
Hi friends,
I wish to fetch some data through vlookup but data to be fetch between condition. example
array on which data
TOTAL DUTY % CD% CENVAT % TOTAL DUTY %
28.85% 10.7000 18.1600 28.86
26.50% 10.6300 15.8700 26.50
25.85% 8.1100 17.7400 25.85
23.55% 8.0500 15.5000 23.55
24.13% 6.5600 17.4900 24.05
20.60% 5.4700 15.1400 20.61
25.26% 7.6000 17.6600 25.26
20.45% 3.4600 16.9900 20.45
18.25% 3.4000 14.8500 18.25
19.25% 2.4300 16.8300 19.26
17.07% 2.3700 14.7000 17.07
16.85% 0.3600 16.4900 16.85
14.71% 0.3000 14.4100 14.71
17.24% 0.3000 14.4100 14.71
26.87% 10.6400 16.2100 26.85
DATA TO BE LOOKUP
28.90%
28.80%
26.50%
25.90%
23.60%
23.50%
SUPPOSE I WANT TO LOOKUP 28.90 IT WILL GIVE DATA of 28.85
and if i lookup 28.80 it also give data of 28.85 so i have search value which may be +.1 to -.01 differ from table of array.
Please help.
I wish to fetch some data through vlookup but data to be fetch between condition. example
array on which data
TOTAL DUTY % CD% CENVAT % TOTAL DUTY %
28.85% 10.7000 18.1600 28.86
26.50% 10.6300 15.8700 26.50
25.85% 8.1100 17.7400 25.85
23.55% 8.0500 15.5000 23.55
24.13% 6.5600 17.4900 24.05
20.60% 5.4700 15.1400 20.61
25.26% 7.6000 17.6600 25.26
20.45% 3.4600 16.9900 20.45
18.25% 3.4000 14.8500 18.25
19.25% 2.4300 16.8300 19.26
17.07% 2.3700 14.7000 17.07
16.85% 0.3600 16.4900 16.85
14.71% 0.3000 14.4100 14.71
17.24% 0.3000 14.4100 14.71
26.87% 10.6400 16.2100 26.85
DATA TO BE LOOKUP
28.90%
28.80%
26.50%
25.90%
23.60%
23.50%
SUPPOSE I WANT TO LOOKUP 28.90 IT WILL GIVE DATA of 28.85
and if i lookup 28.80 it also give data of 28.85 so i have search value which may be +.1 to -.01 differ from table of array.
Please help.