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.

The vlookup search_Key is something like this


The vlookup range uses regexextract to get the search_key from the first column of the range which has a string that contains the search_key.

For example

GK0083 gustav klimt poppy field.jpg
GK0087-gustav-klimt kirche in cassone.jpg

So how do I use regexextract within vlookup to lookup the search_key from a no pattern string that contains the search_key.

I using this


But this only seems to work when the search_key is at the end of the string or if the string only contains the earch_key.

1 Answer 1


This was solved using the following at this thread


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.