Barcode Data - Look up data

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
 
T

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.
 
G

Guest

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Run Macro Upon Entering Data into Cell/s 3
Worksheet program to convert parent/children data to string(s) 1
Use a List to Generate Worksheets 4
Naming non-contigent cells with vba 5
REARRANGEMENT OF CELL VALUES !! 4
Create if partial match then copy and paste data from one cell to another 1

Top