#1
|
|||
|
|||
Look up
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. Last edited by GavinY; 03-20-2017 at 02:59 AM. Reason: Data format |
#2
|
|||
|
|||
=lookup([lookupvalue],b1:b6,a1:a6)
|
|