vlookup amount with tolerance of + or minus 10
Posted on 2014-08-11
is there a formula that will allow me to lookup an amount from one sheet onto another sheet with a tolerance of 10
i.e. I have a column that is already doing a lookup and will return either match or no match.
so, in sheet1, if T2 = Match I need to lookup S2 in Sheet2 find the amount in the amount in R2 and if that amount is +/- 10 to the amount in Sheet1 R2 Match if not No Match.
so it would be something like this
but I need the tolerance of+/- 10
is that possible??
Thanks in advance