Vlookup using Regex Extract - Google Sheets

Question

I trying to do insert an image into a cell in google sheets. I'm using vlookup and regex extract to lookup columns to retrieve the image URL for the IMAGE function in google sheets.

However one of the lookup columns has the lookup value (SKU) but in a string.

When the string ends with the lookup value (SKU) it works, when it starts with the lookup value (SKU) it does'nt work.

I have shared the sheet with examples where it works and where it doesn't.

I'd like it to work regardless of where the lookup value is (SKU) in the string even it the string has special characters.

pnuts · Accepted Answer · 2018-12-08 21:11:52Z

2

This should fetch you two more images and I doubt you need to cater for where the SKU is at the end of the string:

=image(iferror(vlookup(A2&"*",Sheet2!A:B,2,0),vlookup("*"&A2&"*",Sheet2!A:B,2,0)),1)

For GK0095 I think you have an unrelated issue.

answered Dec 8, 2018 at 21:11

pnuts

59.8k11 gold badges93 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2240778 Over a year ago

Thank you very much, that seems to have solved the problem, GK0095 didn't work cause of an issue with the URL itself.

Collectives™ on Stack Overflow

Vlookup using Regex Extract - Google Sheets

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related