Dynamic Data links

Hi I’m trying to create a table that links to two separate websites based on the data contained within the table. For example, when the data in the row is Foo, I want to go to google.com/foo, but if it was instead bar, I’d want to go to bing.com/bar. I know I can use the data itself within the link, but I don’t know how to configure it so that I go to completely different domains depending on the value of the row. Could anyone please advise?


I would also like to know if this is possible.