Excel 2007 : How do I copy data related to duplicates in column a to another sheet to make a map?

[zkit18]

I need help creating a "map" of our inventory. I have a workbook with 2 sheets. The first sheet is the sheet that will have the map on it, the second has a data dump of our inventory.

Basically the important data columns are as follows
I need to take every instance of the location (from M, P, S, and V) in A and paste the type (from I) into the proper cell on the first sheet.

A is the location name from the data dump
I is the type
M, P, S, and V have the locations to search A for. (These columns are not part of the data dump, they are the rows on the shelves arranged in the basic layout of the storeroom)

__A______I_______M______P______S_______ V
A2301...Done.......A2501....B2501....C2501....D0101
A2301...Done.......A2401....B2401....C2401....D0201
A2301...Done.......A2301....B2301....C2301....D0301
B2201...WIP........A2201....B2201....C2201....D0401
B2201...Part........A2101....B2101....C2101....D0501


If someone can tell me how to get it to search the column and paste the type for every duplicate onto the first sheet, I can figure out how to point it to the proper cell
A1 and A2 match with M3 so on the map on sheet one in the row for A2301 will have 3 cells that say Done
A4 and A5 match P4 so on the map on sheet one in the row for B2201 will have 1 cell that says WIP and one cell that says Part

Any help would be greatly appreciated.

[zkit18]

Can someone at least tell me if this is possible, or if I need to clarify what I am trying to do? Thanks

[am0251]

Can you upload your Excel File to try ?

[zkit18]

I deleted a lot of the data (IAW IPSec) but all the important stuff is left. I am trying to make it so that every time there is an occurance of a location in column A (on the second sheet) it will paste the class from column I into the far right map (on the first sheet). The more occurances = more spots in that row that have the class filled in.

Example
A2101 has one entry for Done, and one for Part. Thus on the far right map, in the row designated A2101 (location names are listed in the 2nd map from the right) there will be one cell marked Done and one marked Part.

I am using Vlookup but it only shows the first instance. The duplicates get ignored.

Does this make sence? If you know an easier way to do this I am open to suggestions, they just want it to be in an excel file that you can just dump the data into and have it show the proper locations.

Thanks for any help you can give.

[zkit18]

Anyone know if there's a way for Vlookup to select anything other than the first occurance of the search criteria? Or possibly a different function that will select the duplicates one at a time?

[zkit18]

No ideas at all?

[zkit18]

Does anyone at leas know if it is possible?