That's exactly what I needed. Works perfect.
Many thanks!!!
Tom
On Jan 27, 12:55 pm, kassie <kassie_kassel...@xxx.com(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,FALSE),"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 <kassie_kassel...@xxx.com(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 -
|
Similar Threads
