Forum Discussion
fai_25
Oct 18, 2023Copper Contributor
Updating a row in Excel based on data entered in a cell in that row
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) ...
- Oct 18, 2023
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
OliverScheurich
Oct 18, 2023Gold 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