1

I have a table that has all my different SKU's in item number and shows the dates the product should arrive. I want to be able to enter the item number and get a list showing when the product will arrive, with the amount. For example as shown below - I would enter "1022-175" as the Item Number, I want the result to show the following:

  1. Jan15 7000
  2. Jan22 4005

Here is the table:

Item Num Jan1 Jan8 Jan15 Jan22 Jan29
1022-158 1000 5000 6000
1022-175 7000 4005

I am using Excel 365. Any help would be greatly appreciated.

Improve this question

1 Answer 1

Reset to default
0

You can use these formulas:

  • dates: INDEX($B$2:$F$3,MATCH($A$6,$A$2:$A$3,0),0)
  • amounts: =TRANSPOSE(FILTER(INDEX($B$2:$F$3,MATCH($A$6,$A$2:$A$3,0),0),INDEX($B$2:$F$3,MATCH($A$6,$A$2:$A$3,0),0)<>""))

enter image description here

Improve this answer
3
  • Hi Mate, when I use the date formula, it gives me the amounts in columns, not dates. Also, the information is not in rows like the second formula (which I think can be adressed with the transpose function).
    – Eagle1105
    Commented Aug 12, 2021 at 22:24
  • You can change number format of cells, that'll fix the issue
    – Máté Juhász
    Commented Aug 12, 2021 at 23:10
  • Thank you for your help! This worked!
    – Eagle1105
    Commented Sep 24, 2021 at 15:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .