Cross Match Information and Replace in Right Collumn

I've exported some data from Facebook and im trying to put in order some posts according to the amount of likes.

I have managed to pull some thumbnail links that allow me to quickly see how the post looks( Using =IMAGE() ) which saves me time while im sorting through thousands of posts.

However, Facebook constantly changes URL links for thumbnails and now its showing me errors in the Preview Image collumn: "URL Signature Expired". (Can check on Sheet B: Link 6 Hyperlink)

I was able to get new links for the feed posts in a new worksheet, but this new worksheet is not as organized as the other was. I want to be able to crossmatch using Something like: If the description of the post is equal, replace the url link.

Thank you!

Hi mktdata,

Here is a file into which you can build out a sample for us:

https://docs.google.com/spreadsheets...gid=2100307022

Let us know when it is done.

I dont see any "URL Signature Failure" errors, or any column called "preview image".

I suggest you improve your description by giving the correct names of columns, and also provide the column letters and row numbers where you want help, so that there is no confusion about what you are talking about.

Sheet B cell B2 has linked text "Link 1".

Since this is not created by formula, the only way to get linked text to change is to use Apps Scripts.

See example here: Add links to a cell in Google Sheets using Apps Script

Hi, for some reason that spreadsheet you sent wasnt updated. Can you check again? So on Sheet A Link 5 should be switching with Link 6 on Sheet B(given that the post description matched). It can be copy pasted as a text as well, not obligatory to come as an Hyperlink.

Hi mkdata,

Sheet A and Sheet B have many different descriptions, so you still have the same issue that you cannot do this with formulas.

Your only option is to use apps scripts.