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

And your problem is?
--
Hth

Kassie Kasselman


"Tom" wrote:

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.

On Jan 27, 11:31 am, kassie (Change xxx to
hotmail) wrote:
And your problem is?
--
Hth

Kassie Kasselman



"Tom" wrote:
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- Hide quoted text -- Show quoted text -

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,F ALSE),"No such
record",VLOOKUP(A2,Sheet2!A2:G500,2,FALSE))
--
Hth

Kassie Kasselman


"Tom" wrote:

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.

On Jan 27, 11:31 am, kassie (Change xxx to
hotmail) wrote:
And your problem is?
--
Hth

Kassie Kasselman



"Tom" wrote:
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- Hide quoted text -- Show quoted text -

That's exactly what I needed. Works perfect.

Many thanks!!!

Tom

On Jan 27, 12:55 pm, kassie (Change xxx to
hotmail) wrote:
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,F ALSE),"No such
record",VLOOKUP(A2,Sheet2!A2:G500,2,FALSE))
--
Hth

Kassie Kasselman



"Tom" wrote:
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.

On Jan 27, 11:31 am, kassie (Change xxx to
hotmail) wrote:
And your problem is?
--
Hth

Kassie Kasselman

"Tom" wrote:
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- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -

Glad I could help!
--
Hth

Kassie Kasselman


"Tom" wrote:

That's exactly what I needed. Works perfect.

Many thanks!!!

Tom

On Jan 27, 12:55 pm, kassie (Change xxx to
hotmail) wrote:
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,F ALSE),"No such
record",VLOOKUP(A2,Sheet2!A2:G500,2,FALSE))
--
Hth

Kassie Kasselman



"Tom" wrote:
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.

On Jan 27, 11:31 am, kassie (Change xxx to
hotmail) wrote:
And your problem is?
--
Hth

Kassie Kasselman

"Tom" wrote:
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- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -