Hi, I'm truing to match 2 sheets that contain of the row is the same "and in the same order" and on the other list contain of the column is the same but in different order. Can some one assist me to solve this issue.
Hi, I'm truing to match 2 sheets that contain of the row is the same "and in the same order" and on the other list contain of the column is the same but in different order. Can some one assist me to solve this issue.
Last edited by vlaxo085; 03-02-2016 at 06:56 PM.
not sure, what you looking for, could you please upload a sample file here with expected result.
If answer helped you say Thanks by Add Reputation
Hi, welcome to the forum
I agree that we need for detail/info, but perhaps this will get you started?
A B C D E 23aa 11cc 33 24bb 22 25cc 33 26dd 44 27ee 55
D23 is what you are searching for
E23=VLOOKUP(D23,$A$23:$B$27,2,0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for your assistance. I created the formula correctly, what I didn't actually saw is that is that on the list from witch I was extracting information... data in the row had two blank space ... I used TRIM function to get rid of the blanks and formula was working fine.
So did that work for you?
Yes thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks