Something like this
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
1 |
IDX |
Supplier |
RejNum |
DateIssu |
QtyRej |
Ship |
Item |
Descr |
Category | |
List |
2 |
1 |
Bobalee |
109016 |
07/03/2018 |
1 | |
S2J1014 |
CYL CAB TILT |
Function | |
Function |
3 |
2 |
Bobalee |
109180 |
07/10/2018 |
1 | |
S3J0193 |
CYL ASSY BEAM TOP |
Dimensional | |
Dimensional |
4 |
3 |
Bobalee |
179 |
09/26/2018 |
1 | |
T2J0087 |
CYL CAB TILT |
Missing | |
Missing |
5 |
4 |
Bobalee |
382 |
10/16/2018 |
1 | |
S2J1014 |
CYL CAB TILT |
Orifice | |
Orifice |
6 |
5 |
Bobalee |
111 |
10/18/2018 |
1 | |
S2J1014 |
CYL CAB TILT |
Function | | |
7 |
6 |
Bobalee |
222 |
11/02/2018 |
2 | |
S3J0193 |
CYL ASSY BEAM TOP |
Dimensional | | |
<tbody>
</tbody>
Array formula in K2 copied down
=IFERROR(INDEX($I$2:$I$7,MATCH(0,COUNTIF(K$1:K1,I$2:I$7),0)),"")
Ctrl+Shift+Enter
M.