Forum Discussion
Excel formula with barcode scanner
Hey everyone, I can't figure out how to create a formula to do the following - hopefully someone could help: I have 2000 rows of 3 columns (Serial #s, IMEI #s, and SIM card #s).On my spreadsheet...
Assuming your new sheet has Serial# in column A and Location in column B, you can find the IMEI# and the SIM# from your first sheet (assume Serial in A, IMEI in B and SIM in C) via a VLOOKUP function. Easiest if you put both sheets in the same workbook. Sheet1 has your location data and Sheet2 your original list. I suppose that both sheets have a header row.
The formula in C2 on Sheet1 could be =VLOOKUP(A2,Sheet2!A:C,2,FALSE) and in In D2 you put =VLOOKUP(A2,Sheet2!A:C,3,FALSE)
Then you copy both formulae down your 2000 rows. Should work just fine for a one time solution. Good luck!