Vlookup...Hlookup...Index/Match...help!!!

mnasiatka

New Member
Joined
Oct 19, 2015
Messages
2
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 --
 
Last edited by a moderator:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,236
Messages
6,170,906
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top