lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I have a large dataset of account numbers (column A) and account names (column B). I'm trying to update/fix a rolling forecast with missing account names, and if I use vlookup I get a spill because the entries happen multiple times.
If I Take the account number/names list and remove all on both columns, will they stay matched? They should since the deleted rows will have duplicates in both cells, correct?
If I Take the account number/names list and remove all on both columns, will they stay matched? They should since the deleted rows will have duplicates in both cells, correct?