Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |