Matching text on one sheet to another

[JakeMann]

Good morning,

If I have an item and a supplier of that item listed in one sheet, is it possible for a formula to look at that supplier and item, match the supplier to another page named after the supplier and then return the necessary data?

I know this seems a little over complicated but the main worksheet changes information every time you enter a new item into it.

I am currently using a HLookup to pull through the data into a complete table, but I only want to it read data applicable to that supplier.

I've attached the document.

AI11 shows the item and AH12 lists the suppliers. What I want is the first supplier to appear in AL11 and then I can play with a formula to pull the data through.

Thanks

[vlady]

don't know if this is what you are looking for

=INDIRECT("'"&AH12&"'!B$6")- with the sample table will get the first supplier

[JakeMann]

That's great, thank you.

[vlady]

Welcome!!!