Need Excel formula to pull data from multiple worksheets
Thanks in advance for your feedback in help:
I have different products, with different prices in different areas. Each worksheet is based on the area the products are located in. Then on each worksheet, I have 2 columns, one with the product name and another with the product price.
I want a formula for a main page where I can type in the name of the product regardless of which sheet it's on and it will pull the price from the sheet that is related to the product.
I have a formula using index and match, have tried formulas using lookup, but they only work for one page. What can I do or what do I need put in the formula so that it will scan the same area on each page for the product name I input on the main page and return the price related to it?