I have a list of names and their assorted properties.

I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.

Currently I can accomplish this by copy and pasting the entire row, but this is not elegant nor dynamic (the number in blue does *not* update with this method):

My ideal solution: A name is typed into the "Name" column. The spreadsheet program pulls the associated row from the "main" sheet into the new sheet.

I am currently using Numbers.app, but am curious if this is possible in Excel, OpenOffice Calc, Google Docs, or any other spreadsheet program. Thank you.

## Best Answer

In Excel VLOOKUP "Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array."

Taking your info as posted, I created a table on the first sheet and this on the second sheet;

`=VLOOKUP(A2,Sheet1!A1:D6,2,FALSE)`

Type the name into A2 and B2 will look up the color value for the name "Dagger" in the first column of the first sheet. You will notice the array

`Sheet1!A1:D6`

given in the formula, that is your table on the first sheet. The number`2`

is the column to get the data from. So to get the size, change the column index to`3`

and so on.If you change the data in the table on the first sheet, the data will update.