Hello guys,
Newbie/Noob here, need your hand on this one:
A | B | C | D | E | |
1 | H058 | B057 | C062 | H059 | |
2 | 1-Nov | 18,000 | |||
3 | 2-Nov | 2,000 | 3,000 | ||
4 | 3-Nov | 20,000 | 15,000 | ||
5 | 4-Nov | 10,000 | 15,000 |
B1:E1 is my SW Code
B2:E5 are my quantity
need to do something like xlookup but don't know how to do it. Here's my question,
on another sheet, if my lookup value is on the Column A, how can I get its all quantity and SW Code using a formula or a VBA? Something like this:
Date: | SW Code | Quantity |
3-Nov | B057 | 20,000 |
C062 | 15,000 |
3-Nov is my lookup value
B057 & C062 / 20,000 & 15,000 are my result on lookup
Thanks in advance!