Hi all,

I have two spreadsheets. Spreadsheet 1 contains an invoice # (A:A) and Part
# (B:B). Spreadsheet 2 Contains the same information invoice # (C:C) and Part
# (E:E).

On Spreadsheet 1,each invoice contains multiple partnumbers.
ColA ColB
89853656 FS485AW#ABA
89853656 AH058AA
89853657 RA373AA#ABA
89853694 KD911A4#ABA
89853694 U4414E
89853694 CC532A
89853694 KP080AA#ABA

On spreadsheet 2, if my serial number, 89853694, exists on Sheet 1 lookup my
part number, U4414E. If my part number, U4414E is found, return U4414E -
else return "".

Thanks,