Forum Discussion
Match names between two sheets and return value of a cell in the row
A simple solution using VLOOKUP function is all you need.
Please see the attachment file.
But you have to learn how to use the VLOOKUP correctly and safely!
Here some sources about it:
https://support.office.com/en-us/article/VLOOKUP-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://exceljet.net/excel-functions/excel-vlookup-function
Excel spreadsheet removes nothing if only you don't use *.csv format, and VLOOKUP doesn't require Excel Table, you may work with ranges.
SergeiBaklan The document I have been working with has a number of tabs. When I created tables, the document would not open. A note saying the file is corrupt comes up and Microsoft has fixed it. Then the list of tables I created come up to say the tables are gone and the formulas that were once all over the document are no longer there (just the numerical value of the formulas are left)
For this reason, I gave up on vlookup and have replaced most of the vlook up with complex formulas. I have also worked on combining tabs to make it easier to work with. The INDEX MATCH might be what I need to achieve my updated workbook
Stacey
Yeah INDEX MATCH doesn't work because the layout of the information added each month changes and the location of one cell may be in a different spot the next month