Reputation: 672
My excel have 2 sheet. First sheet contains a Target column. There is a Point Column as well. I want if the target value in between sheet2 then corresponding point of sheet2 is plased in the Point column of sheet1. I try using vlookup but its works only the value of sheet2 is exactly same, not in the range. Any help will be appricite.
Upvotes: 0
Views: 51
Reputation: 316
Note that the sheet should give point n
if it is between (n-1)*100000+1
and n*100000
.
So just take D5 = ROUNDUP(B5/100000, 0)
and it will work, in this specific case.
It is also likely to be much faster than using VLOOKUP
.
Upvotes: 1