• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

find data through vlookup condition data between two value

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.
 
What do you want to do with the data, Display it or Sum or Average it?
 
upload_2014-10-30_21-15-20.png
see attached file:
 

Attachments

  • query data_Hui.xlsx
    10.5 KB · Views: 17
i want to display data
Dear Hui
Thanks for your support but if i change variance from hole number to decimal number i.e from 1% to .01% it is not showing data as today i am not able to explore your formula so i need your help to sort out quickly i am uploading you reply file with my condition. Please take a look.

Once again very very thank for you attention to my problem.
 

Attachments

  • query data_Hui.xlsx
    13.1 KB · Views: 23
Looking up 28.8% +/- 0.01% is giving a range of 28.79% - 28.81%
There is no data within that range

Try changing 0.01% to 0.06% and it will pickup the first entry
Note that the values in Column C are rounded to 2 decimals
 
Looking up 28.8% +/- 0.01% is giving a range of 28.79% - 28.81%
There is no data within that range

Try changing 0.01% to 0.06% and it will pickup the first entry
Note that the values in Column C are rounded to 2 decimals
Dear Hui
Thanks for reply

Sorry i have over look the data to be find.

Thanks it is working fine.
 
Back
Top