Greetings
I am not sure whether my goal can be acccomplished through a funtion or if I
will have to use code. I have an inventory spreadsheet that has part numbers
on hand qty and on order qty.
Part #
On Hand
On Order

Because of the layout of the sheet the Part# may appear in different rows or
different columns, but its always in row 3,6,9, etc. I would like to either
through input box and code, or a formula be able to enter the part# and get
the total on hand and on order.
Thanks