D
Debi
I have a list of customer numbers and serial numbers. I need a formula that will find the customer number in a list, then fill the cell with the serial number (contains alpha and numeric characters, ie BBB1001).
Example: If the value in cell A2 is equal to 1234, then find 1234 in a range (B2:B100), and retrive the serial number in a range (C2:C100).
Thank you for your help.
Example: If the value in cell A2 is equal to 1234, then find 1234 in a range (B2:B100), and retrive the serial number in a range (C2:C100).
Thank you for your help.