Help! How to delete record from two columns if vlookup returns value??

[robyboy123]

Well hy everyone!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I desperate need help on my xls file. Here’s the deal. I have two columns containing id numbers. I used vlookup in the third column to find an id from the first column, and the range is the second column. Now if the vlookup finds the id, it returns the same id found in the search range (second column), otherwise it returns N/A, and that’s fine for me..<o></o>
<o> </o>
Here is the actual problem. A must now define a function which will compare the 1. and the 3. column, and if they match it should delete it from both the first and second column. <o></o>
I defined this =IF(ISNA(C578);A578;REPLACE(A578;1;40;""))<o></o>
Now I know this is not an elegant way of performing this task, and also I don’t know how to force excel to delete the same id number from the second column too ?? <o></o>
I’m worried about the "" … will this enter a space ( char(32)) in the row ? This could be a problem because I have to export the data back, and the space (blank) sign might be a problem. <o></o>
<o> </o>
So to clear things out, a have to delete the identical id’s form the first and second column. <o></o>
<o> </o>
Thnx in advance <o></o>

 

[robyboy123]

Stil got no clue how to slove it ...

anyone?

 

[John Davis]

Well hy everyone!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I desperate need help on my xls file. Here’s the deal. I have two columns containing id numbers. I used vlookup in the third column to find an id from the first column, and the range is the second column. Now if the vlookup finds the id, it returns the same id found in the search range (second column), otherwise it returns N/A, and that’s fine for me..<o></o>
<o> </o>
Here is the actual problem. A must now define a function which will compare the 1. and the 3. column, and if they match it should delete it from both the first and second column. <o></o>
I defined this =IF(ISNA(C578);A578;REPLACE(A578;1;40;""))<o></o>
Now I know this is not an elegant way of performing this task, and also I don’t know how to force excel to delete the same id number from the second column too ?? <o></o>
I’m worried about the "" … will this enter a space ( char(32)) in the row ? This could be a problem because I have to export the data back, and the space (blank) sign might be a problem. <o></o>
<o> </o>
So to clear things out, a have to delete the identical id’s form the first and second column. <o></o>
<o> </o>
Thnx in advance <o></o>

Looks like you're doing everything manually. You could copy and paste special on Column C, replace N/A with "" and then sort on Column C, then A. That would bring all you're dupe to the top. This will at least get you a bump.

BTW "" this is the Null sign a space would be indicated by " "