Finding record in another table and returning a field

Hi, please help. I want to find the value entered in LinkUrl1 in the tabel EV strategy and then return WEV Brand Page from that table to URL1. thanks