I have tried them all to no avail.
I am looking to perform a type of lookup. On Tab “Sheet1” I have raw data, each name has 3 rows. I need to find a specific row based: Matching Name from sheet2 to sheet1 and where the Type is “Date”. From that identified row, I want to put the dates in the correct column on Sheet2, based on the month/year. As an FYI, right now the sheet2 titles are dates, ie 1/1/18, formatted to display Jan 2018. My initial thought was to use greater than / equal to B1 and less than C1.
The data columns will continue to grow as new data is collected.
I have tried a dozen different things, but can’t make any of them function like I need. My next step is to write a VBA for it, but didn’t want to go that route, just yet. Hoping someone in the forum can help!
-- corrupted image removed --
I am looking to perform a type of lookup. On Tab “Sheet1” I have raw data, each name has 3 rows. I need to find a specific row based: Matching Name from sheet2 to sheet1 and where the Type is “Date”. From that identified row, I want to put the dates in the correct column on Sheet2, based on the month/year. As an FYI, right now the sheet2 titles are dates, ie 1/1/18, formatted to display Jan 2018. My initial thought was to use greater than / equal to B1 and less than C1.
The data columns will continue to grow as new data is collected.
I have tried a dozen different things, but can’t make any of them function like I need. My next step is to write a VBA for it, but didn’t want to go that route, just yet. Hoping someone in the forum can help!
-- corrupted image removed --
Last edited by a moderator:
