# Range of data and IF then problem maybe Vlookup awell

1. ## Range of data and IF then problem maybe Vlookup awell

I have a table of data which provides ranges that my inputs can fall between

"Table"
1600
1470
1330
1200
1070
930
820
780
680
590

Basically when I get a number say 1220, I want to check which values it is in between and then compute the percentage the 1220 is of the range.
For example
IF 1220 is in the range of the "table", find what two values it is between which is 1330 and 1200.
then take the number above 1220 which is 1330 and the number below 1220 which is 1200 and perform this calculation
(1330-1220)/(1330-1200) to get a percentage of the range.

Cheers
Any ideas would be appreciated.  Register To Reply

2. ## Re: Range of data and IF then problem maybe Vlookup awell

try this
and F1:F10 is your range (replace to match wherever your data is) ``Please Login or Register  to view this content.``
of course this gives an error either above or below your range  Register To Reply

3. ## Re: Range of data and IF then problem maybe Vlookup awell

Im getting a #REF error with this
ExcelPRoblem.png  Register To Reply

4. ## Re: Range of data and IF then problem maybe Vlookup awell

Never mind I resolved it, just had to sort the columns in ascending order.

Cheers  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 