I am useing VLOOKUP to fill in a pipe inspection form, the problem is whem the size goes over 4" the tolerances change from +/- .03 to +.06 / -.03. I have the formula as VLOOKUP(f3,j3:u124,7,)-.03... How do I use the input size to change the tolerance?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
bensonsearch
Well-known Member
- Joined
- May 26, 2011
- Messages
- 844
HI,
if i understand correctly you need to change the -3 at the end? if so then use another cell to input the variance. lets just say X2 for the sake of it.
VLOOKUP(f3,j3:u124,7,)-X2
if i understand correctly you need to change the -3 at the end? if so then use another cell to input the variance. lets just say X2 for the sake of it.
VLOOKUP(f3,j3:u124,7,)-X2
Upvote
0
Similar threads
- Question
