vlookup specific description from multiple tabs under specific header name in one column

Hi all, thank you advance for your help. Looking for a simple formula/vlookup to match some data across multiple tabs for reconciliation. Example attached.

Master_Copy sheet = this is loaded into a system and sometimes the system have a habit of not being able to load all the prices in one go so it does it by batches.
?Price matched? tabs 1, 2 and 3 will show what is ?matched_prices? and not matched which means what has been loaded successfully and not.
Ideally in tab sheet ?Compare? from column I, I would like to have a formula/vlookup to look up from ?Price matched 1? sheet to only capture any row under column header ?Matched_Prices? only.
In each of the ?Price matched? tabs 1, 2 and 3 sheet will have several columns headers and all consistence but I only want to look and capture rows under column header ?Matched_Prices? only.

So in Compare sheet, I?m looking for code ?AAA? therefore, look at ?Price matched 1? tab and lookup under column header ?Matched_Prices? if code ?AAA? is there, if yes then copy or capture the row A to G, if not go to ?Price matched 2? tab etc.

Hope I'm making sense. Thank you again in advance for your help.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

@trpltwo

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.


- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.