Hi!
I'm trying to create an "Order Sheet" for our warehouse where the person inputting the order types in the part number and Excel will pull up the part description. I can use DGET for the first line but after that I can't use the same formula since DGET can't look more than one row above the entry.
I've used excel in a limited fashion before so this is my first foray into the more complex functions so this may be super simple and I can't find it. Hopefully my poor description of the problem provides enough info to solve this. Thanks for all the help.
I'm trying to create an "Order Sheet" for our warehouse where the person inputting the order types in the part number and Excel will pull up the part description. I can use DGET for the first line but after that I can't use the same formula since DGET can't look more than one row above the entry.
I've used excel in a limited fashion before so this is my first foray into the more complex functions so this may be super simple and I can't find it. Hopefully my poor description of the problem provides enough info to solve this. Thanks for all the help.
