Columns comparison
Closed
Veda
-
Feb 16, 2010 at 02:15 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 05:37 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 05:37 PM
Related:
- Columns comparison
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to remove columns in word - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Excel partial text match between two columns - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 16, 2010 at 05:37 PM
Feb 16, 2010 at 05:37 PM
I am not sure if that can be done via function. The reason being as soon as you delete E, vlookup will fail. So to me it seem macro would be required. But even with macro, VLOOKUP needs to be changed to a value. I dont know if this would fit your design ?
