Looking for plus/minus in VLookup data

[Graham52]

Hi, I use a spreadsheet that uses a formula to find whether the part needed for a job is standard or do we need a custom made piece. This is the formula IF(ISERROR(VLOOKUP(C31,G40:H83,2,0)),(B31*C31)*H38,VLOOKUP(C31,G40:H83,2,0)) and the data base it searches has all our standard sizes in it. I do have a tolerance of +/- 5mm of the standard size and I want to know if this can be added into the formula to allow for this. Simply put can VLookup search for and give a result that is within +/- 5 of the data in a cell. So sorry if this is all too confusing.

Thanks for any help offered.

Graham

 

[Fazza]

hello, Graham

Please post some sample data - exact, within the ±5, and not within the ±5.

thanks, Fazza

 

[Graham52]

hello, Graham

Please post some sample data - exact, within the ±5, and not within the ±5.

thanks, Fazza

Hi Fazza and thank you for your reply, I'm sorry but I don't understand what you are asking me to supply.

Thanks, Graham