I have a file with 2 sheets:
Sheet1:
image URL | product name
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/903741.jpg | aaa
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/77842.jpg | bbb
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/524745.jpg | ccc
Sheet2:
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/903741.jpg
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/77842.jpg
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/524745.jpg
I'm trying to vlookup the URLs from Sheet2 into Sheet1 and retrieve the product name.
I tried: vlookup(A2, Sheet1!A:B,2) but that gave me
ccc
bbb
#N/A
Is there any way to get this to work?
tnx!
Sheet1:
image URL | product name
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/903741.jpg | aaa
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/77842.jpg | bbb
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/524745.jpg | ccc
Sheet2:
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/903741.jpg
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/77842.jpg
http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/524745.jpg
I'm trying to vlookup the URLs from Sheet2 into Sheet1 and retrieve the product name.
I tried: vlookup(A2, Sheet1!A:B,2) but that gave me
ccc
bbb
#N/A
Is there any way to get this to work?
tnx!