Barcode Data - Look up data

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Scanning barcode data into a cell, say A1, and need to reference this
data to another sheet that has this same data which was imported from
buisness software that has relevent data in the row which I want
transfered to the first sheet into cells A2, A3 ect..

Example: I scan the Job # into Cell A1. For cells A2, A3 etc, I need
to look up data in another sheet referencing the data in Cell A1 (same
Job #) such as PO , Customer, Date... then this data would end up in
A2, A3, etc.

Thanks,
Tom
 
Wanting to use data in one cell of sheet 1 and finding same data in
sheet 2, then copying the data of that row into the first sheet.
 
You can use VLOOKUP
With your data in say A2 of Sheet 1, and the other data in Sheet 2, A2:G500,
then in Sheet 1, B2 enter =VLOOKUP(A2,Sheet2!A2:G500,2,FALSE) to read the
data in Sheet 2 B2. Change the 2 to 3 to read the data in Sheet 2, C2 and so
on.

You can also add refinements, such as =IF(A2="","",VLOOKUP...... so that,
until you enter something in A2, B2 will remain blank. Even
=IF(A2="","",IF(ISNA(VLOOKUP(A2,Sheet2!A2:G500,1,FALSE),"No such
record",VLOOKUP(A2,Sheet2!A2:G500,2,FALSE))
 
Back
Top