What I want to accomplish essentially is when I type in a number in one cell (a1 for example under category product number) that the information about that product shows up in the other cells (b1 c1..... ) such as the name of product, location.
It would essentially be searching for the product number and information from another page where a range of information is with all the different product numbers
Bookmarks