VLOOKUP with multiple values

[NickPDC]

Hey Guys,

Having a problem with using VLOOKUP in Excel.
Basically I have a sheet (attached [Test.xlsx]) which I am trying to pull data to from another sheet (attached [Tooling.xlsx]) when the "Tooling Ref" has had a part number inputted into it. Which I can do, and do not have a problem with.

The problem I am having is, I only want data to show up when it has a certain value along that row. It makes sense when you look at the workbooks. I am basically wanting the data to show up that is located in the "PATT SHOP" for instance.

Which is a good 6 rows of data on the "Tooling Sheet" but I want that to show up when the drop down for "PATT SHOP" has been selected on the "Test" sheet if that makes any sense?

I am trying to make it work so all of the data can be selected by selecting a different value from the drop down list?

Hope you can help

Cheers

Nick

[NickPDC]

If I havent made any sense please let me know and I will do my best to describe what I am trying to do!
I have already noticed a bit of missed detail in the description!

I am trying to obtain all of the details for "Pattern Equipment" on the Test sheet from the Tooling workbook. But only the ones that relate to what is in the drop down box on the Test sheet.

Cheers!

[NBVC]

So you only have the one drop down box in I8?

And if so, then in this case, you want 6 matching lines from the Tooling workbook?

It is not really clear.

[NickPDC]

Sorry for being unclear!

I only have the one dropdown box yeah. This is because the rows below will have to be stored in the same location as stated in the drop down if you understand me?

As in, all of the parts listed in the "Tooling" sheet, the ones in the "PATT SHOP" for example, will appear under the PATTERN EQUIPMENT section, when the "PATT SHOP" is selected from the drop down.

The ones stored in the "CORE SHOP" will appear when "CORE SHOP" is selected etc.

But it also has to be looking up the Tooling Ref. at the top of the sheet, as this will change as well, as there will be different part numbers on the "tooling" sheet.

[NBVC]

Ok, give this a try.

While, both books are open, in the Tooling workbook, in H2 enter:

Please Login or Register  to view this content.

and copy down.

In I2 enter:

Please Login or Register  to view this content.

Then in the Test Workbook, in A8 enter:

Please Login or Register  to view this content.

and copy down as far as you can go.

Then copy across to column G.

Note you will need to change the reference after the INDEX to match up. This is because you are using merged columns (which is usually frowned upon).

In I9 enter:

Please Login or Register  to view this content.

copied down.

[NickPDC]

Thanks for the response!

Nearly there!

Nothing changes when I select a new value from the drop down list.

Rack number is showing as "5" when it should show what is in the "Location" on the Tooling workbook.

And "Equipment" should be the same as "Description" on the Tooling workbook. My mistake, I labelled the Column wrong!

Cheers,

Nick

[NBVC]

Not sure what you mean,

See attached.

[NickPDC]

That is perfect!
Works flawlessly , thank you so much!

Applologies for making life difficult with poor descriptions!