List to table based on date

[Toyo613]

Hi All,

One more problem for you and I should be done!

I have a table that goes left to right based on month. I have an export that is list of data that I want to paste into new tab and have the table automatically pick up the data based on name, column header and date.

The issue I'm having is the date, my index match wont pick up the date and Sep data is showing in the month of Aug.

11-23-2017 7-19-49 PM.jpg

[shivya]

Hello Toyo613,

Try this one-

=IF(AND(A3=Data!B5,MAIN!$A$1=Data!F5),OFFSET(Data!$B$4,MATCH(MAIN!A3,Data!$B$5:$B$8,0),MATCH(MAIN!$B$2,Data!$B$4:$F$4,0)-1,1,4),"#NA")

1. Select B3:E3
2. copy and paste this formula
3. ctrl + shift + enter

Drag down..

For reference, find sheet

[shukla.ankur281190]

Try

B2

Please Login or Register  to view this content.

Copy across.

[dunnobe]

Hey there,

Here's my solution to solve it with an IFERROR(index; match)

Just need to find a more flexible solution to refer to the name and date cell that have to be lookuped...

Best regards,

B.

[Toyo613]

Thanks All!!

@shukla.ankur281190, I used your method in the end and it works great. Scaled up to my larger file without issues.