Could you please send me the file so I can see the data layout and try to set up the formulas on it (let me know if you are not familiar with sending files on this site)
Ok, go to www.wikisend.com and upload the file there (no need to sign up). You will then get a page that has the download link and File ID. Copy the download link or the File ID and come back here and paste it in your reply.
If the file has sensitive information let me know before you upload it
I got the file, thanks
Since your formulas are under the 'qty' column, I will assume that you want the formula to return the quantity from column B on 'BRC' where your product matches supplier product on the 'ALT' sheet. Correct?
Ok, since there are multiple occurrences of your product on the ALT sheet you will need a macro to pull them all. I can write the macro for that which can be run on demand by say clicking a button. Would that be ok
Any solution, formulas or macro, will work only on the file that it is designed to work on. You chose to send me that file so I assume you wanted the solution for that file
Yes with that many more sheets it is bound to be a bigger job. If macro is an acceptable option for you, you can send me the actual file and I will have a look and let you