Updating a row in Excel based on data entered in a cell in that row

Copper Contributor

Hello, I have a spreadsheet where one worksheet has a table (table 1) full of data about different projects (which are numbered and separated by row). I have another worksheet with a table (table 2) to allocate different people to those projects. What I usually have to do is duplicate the data through copying and pasting cells from table 1 to table 2. 

What I would like to do is enter the project number into a row in table 2 and for the data in table 1 to populate the row in table 2 - is this possible through Excel or is this more of an automation question?

1 Reply
best response confirmed by fai_25 (Copper Contributor)


I'm sure this can be done with VLOOKUP as well as with INDEX and MATCH in all Excel versions. In more recent versions of Excel you can use XLOOKUP.

Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support

XLOOKUP function - Microsoft Support