List Items corresponding in a table with values repeated both horizontally and vertically

[Danilão]

I need a formula to automatically list all items related to the closest expiration dates.

 

[BobBridges]

You're new, Danilão, so I gotta be nice :
1) "Related" how?
2) The expiration date "nearest" to what?
3) And now that I'm looking at your worksheet, which of those several date columns are the "expiration" date?

You gotta define the question, senhor.

 

[Danilão]

You're new, Danilão, so I gotta be nice :
1) "Related" how?
2) The expiration date "nearest" to what?
3) And now that I'm looking at your worksheet, which of those several date columns are the "expiration" date?

You gotta define the question, senhor.

I filled it in according to what I need...