I've read the other threads on this but not finding what I need.
I have a list of dimensions in A and corresponding parts numbers in B. I want to enter some value in a cell and return the part number that within +-5% of the dimension. Is there anyway to do this?
Obviously this is not working but can I place some sort of condition on the TRUE/FLASE at the end?
=VLOOKUP(A22,$A$1:$B$13,2,0)
I have a list of dimensions in A and corresponding parts numbers in B. I want to enter some value in a cell and return the part number that within +-5% of the dimension. Is there anyway to do this?
Obviously this is not working but can I place some sort of condition on the TRUE/FLASE at the end?
=VLOOKUP(A22,$A$1:$B$13,2,0)
