Hello,
I am looking for some help with a lookup function, I have multiple data of the same value in column A, I am trying to have the data in the corresponding rows in column C displayed if I enter any of the values in column A. in a different sheet, see example.
A B C
200-0956 Wiring Loom 200-1254
200-0956 200-1312
200-0956 200-1012
200-0956 200-1311
200-0956 200-0998
200-0956 200-1255
X66070154S Tray Body T66070000S
X66070154S T66000016S

Sorry having difficulties formatting the information,
200-0956 is in A1-A6
Wiring loom is in B1
200-1254 is in C1
200-1312 in in C2
etc.



I hope that makes sense.