Porkman138
New Member
- Joined
- Jul 8, 2003
- Messages
- 5
Hi there! I need some help with a project here at my work. I've never done anything this complex with Excel before and I'm stuck. I can't figure out the proper syntax for what I want to do. I have a list of data organized in columns by the title of that column. This makeshift database is just a second worksheet within the same book. I need the first worksheet to reference the second worksheet when a piece of data is entered onto the first sheet. Essentially, I need Excel to look at the data entered in column A of the first sheet, reference the entire second sheet, and when it finds a match, populate column B with the title of the column the data is found in on the second sheet. All the entries made into the first sheet will be listed on the second sheet but the column they are listed in may change from time to time. I'm so close to getting it but I feel like I'm missing some tiny obvious thing.