Hello! I'm working on a spreadsheet were sheet 1 contains data for roughly 2000 products. Column A is the product number. Columns B-AC contain information relating to each product number. On sheet 2 I want to be able to type in the product number and have the corresponding information automatically populate. Please tell me what the correct formula or function would be.
Bookmarks