Formula
 

I'm looking for is a formula that
will self populate the form for me. The way the old spreadsheets were set up
was that I had one that was the form and the other was the data spreadsheet.
The colums were all labeled with titles such as item number, date, min, max
and so forth. Each row was a different item. On the form spreadsheet I had
tied certain cells to the data spreadsheet using the formula I can't seem to
remember. I had a preset cell on the form sheet that when I put a number in
the cell on the form spreadsheet (that corresponded with a row number on the
data spreadsheet) it would populate the form with the information from one
item from the data spreadsheet. I just can't remember what the formula was.
I would greatly appreciate any help.

Jesse,

If your cell with the number is cell A1, then something like:

=INDEX(Sheet1!A:A,A1)

copied to the right as far as you need.

HTH,
Bernie
MS Excel MVP


"Jesse13579" wrote in message
...
I'm looking for is a formula that
will self populate the form for me. The way the old spreadsheets were set up
was that I had one that was the form and the other was the data spreadsheet.
The colums were all labeled with titles such as item number, date, min, max
and so forth. Each row was a different item. On the form spreadsheet I had
tied certain cells to the data spreadsheet using the formula I can't seem to
remember. I had a preset cell on the form sheet that when I put a number in
the cell on the form spreadsheet (that corresponded with a row number on the
data spreadsheet) it would populate the form with the information from one
item from the data spreadsheet. I just can't remember what the formula was.
I would greatly appreciate any help.