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
Hello,
Please find the values in Column A,B,D,E

Column A Column B Column D Column E
AA 100 AA 1000
AB 200 AB 2000
AC 300 AE 3000
AD 400 AF 4000


In column C we can get the values using VLookup function by comparing Column A Vs column D.
But the same time the matched values should be deleted in Column E. i.e. In column E the values 1000 & 2000 should be deleted.

Is there any function or macro?

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
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 ?
0