Look up, but it can't be a vlookup

[traveler911]

I am working on an inventory control workbook.

I have created a tab for each station, and then a master tab.

The master tab is sorted alphabetically normally.

The Station tabs are each one is sorted by the order of the items in that station.

Right now, when a item is added to inventory. I am adding to the master, sort by the column for that station. Copy, paste to that stations tab. then print for inventory.

Wasn't a big issue, but now more people are becoming involved, and half do not understand copy and paste.

What I want to do is...
On Station 1 tab, it would look for C$ (Sorted item number 1). The in the stations tab, column c is in 1-200. A4 would lookup from the Master for the name for 1, then B4 would show the item number, etc.

Then I wouldn't have to copy and paste/reformat the page, as it would generate based off the Master tab info.

I hope that makes some kind of sense.

I tried to a vookup, but as the information I want is sorted in a different column for each station I wasn't able to figure it out.

Kent

[scottiex]

maybe in I4 something like

Please Login or Register  to view this content.

the "MATCH($I$3,'Master Sheet'!$B$2:$J$2,FALSE)" is to find how many columns across your data is using the column header. and the titles of the columns on the master sheet