http://www.filedropper.com/simplespreasheet
I have a spreadsheet that im using to find part numbers based on an input of size.
I have added a screen shot of a simplified version of what i am using.
The premise is that you enter the size (In this case 13)
And below it returns the part number (in this case 12349)
What i need help with is adding a formula to the 2 boxes below, so that it can return the SIZE (NOT PART NUMBER) for the next size up and the next size down (In this case 8 & 16)
There will only be 1 of each size and the sizes will never be doubled (In this example i typed in a size twice by error but this doesnt happen on the proper spreadsheet)
Is there a formula i can used based on the input of size (5) to find the next size up and the next size down?
Thank you for your help.
Bookmarks