hello,
In column A:
https://site.com/file/123H.png
https://site.com/file/H456.png
In column C:
123H.png
G132.png
H456.png
I want to scan/search all of both columns to find what's in column C within the http in column A, then return the correct variable in column C in column B (that matches what's in the column A variable)
Last edited by JBeaucaire; 10-12-2016 at 02:24 PM.
Assuming that starts in A1 and C1, put this in B1 and copy down:
=INDEX(A:A, MATCH("*"&C1,A:A, 0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Almost, didn't work because it's match column C one by one, it needs to scan all of column C:C to find the same in column A:A
If http format is constant before the last "/" then try
in B1 and copy down
=VLOOKUP(MID(A1,23,255),C:C,1,0)
or
=INDEX(C:C,MATCH(MID(A1,23,255),C:C,0))
No
Column A Column B Column C
https://files/H11257PZ-01.png #N/A H11263P2-01ALT1.png
https://files/H11257PZ-02.png #N/A H11263P2-02ALT1.png
https://files/H11263P2-01.png #N/A H11263P2-03ALT1.png
So need to find what's in column C to search in column A IF it's found in column A, return what's in column C in column B.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks