Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi. Yes, it's called vlookup.

In the sheet with the most data (table1), you add a column for age. Then in that column you'll pull in the data from the other table with the vlookup function. =vlookup(table1idcolum, table2id:table2age,colcounter,0)