Hello together,
I have a large excel, in one cell it say match yes/no. If it says yes, I want to match the adress through a corresponding code to another sheet.
The example is attached.
Many thanks in advance for your help!
Best regards
Hello together,
I have a large excel, in one cell it say match yes/no. If it says yes, I want to match the adress through a corresponding code to another sheet.
The example is attached.
Many thanks in advance for your help!
Best regards
Why not filter on Yes.
After that copy and paste.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That would be a lot of manual labor, since I would have to then check in the other file for all the corresponding codes). In a file of about 2000 entries
or...
=IFERROR(IF(VLOOKUP($H2,$B:$H,2,FALSE)="Yes",VLOOKUP($H2,$B:$H,1+COLUMNS($I2:I2),FALSE),""),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
in addition to your reply #3.
After that on sheet 2 a countif for the duplicated versions.
And after that deleted (or replace) the other (old) data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks