Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses
formula if you have credit in one column, debit in next column
Jack -
Jackthelad -

4 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

6 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses