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 number2
is the column to get the data from. So to get the size, change the column index to3
and so on.If you change the data in the table on the first sheet, the data will update.