Excel: Can I use absolute or relative references to.....

[Angela]

I have a hundreds of rows of information in an Excel worksheet: product #,
desscription, pricing, etc... the data in each row is unique to the product #
at the beginning of that row. I'll call this 'SHEET 1'

My goal is to create another worksheet (I'll call this 'SHEET 2') that will
allow me to input a product # (from the 'SHEET 1') and have the rest of the
data (from the 'SHEET 1' row) poplate into 'SHEET 2'.

I'm not sure this makes sense. I have looked into absolute references and
it might work, but it seems like it'd only work per field - I don't know how
to do it for a whole row of data.

Any ideas?
Thanks.

 

[JE McGimpsey]

I have a hundreds of rows of information in an Excel worksheet: product #,
desscription, pricing, etc... the data in each row is unique to the product #
at the beginning of that row. I'll call this 'SHEET 1'

My goal is to create another worksheet (I'll call this 'SHEET 2') that will
allow me to input a product # (from the 'SHEET 1') and have the rest of the
data (from the 'SHEET 1' row) poplate into 'SHEET 2'.

I'm not sure this makes sense. I have looked into absolute references and
it might work, but it seems like it'd only work per field - I don't know how
to do it for a whole row of data.

One way:

Assume you want the value from SHEET 1, columns B, C, etc...,
corresponding to your product numbers in SHEET 1, column A. On 'SHEET 2':

A1: <input product number>
B1: =VLOOKUP(A1,'SHEET 1'!$A:$F,2,FALSE)
C1: =VLOOKUP(A1,'SHEET 1'!$A:$F,3,FALSE)
etc.