Lookiing up data depending on date and append type

[InvalidTxtString]

So in sheet1 I have a load of incoming data - this is all gathered by links to other workbooks.

In sheet2 id like to be able to see all items that have a type submitted on the date in "TODAY" which is set to =Today() so it's moving the dates in sheet2 each day

Id like to append the Type to the ITEM when it goes to sheet2

So if item 3181 got T today, it would show up as "3181 T" - I'm willing to change the layout, if its easier to insert a column more on each day in sheet2 for the TYPE, so instead of one cell for "3181 T", it would be "3181" and then "T"

Thanks in advance <3

http://www.excelforum.com/attachment...1&d=1470157553

[oeldere]

I should re-arange the data in a verticaly way (talble).

After that I would use a pivot table.

[InvalidTxtString]

I cant do pivot table as I cant see how it would be updating correctly backwards and forwards? in Sheet2

[JohnTopley]

Try

in E6

=IFERROR(INDEX(Sheet1!$A$4:$A$1000,SMALL(IF(INDEX(Sheet1!$G$4:$NG$1000,,MATCH(TODAY(),Sheet1!$G$3:$NG$3,0))<>"",ROW($A$4:$A$1000)-ROW($A$4)+1,""),ROWS($A$4:A4))),"")

Enter with Ctrl+Shift+Enter

This will return the Item number.

With separate column for the TYPE (per date):

in F6 (as an example)

=VLOOKUP($E6,Sheet1!$A$4:$NG$1000,MATCH(TODAY(),Sheet1!$A$3:$NG$3,0),0)

Range references will change if you add the extra columns

[JohnTopley]

See attached ..

[InvalidTxtString]

See attached ..

You're a gift that just keeps on giving John.

Thank you!