I have attached my spreadsheet for your review. The first tab is called “Data” and has six columns. Column A “Trancode” is the column I want to search on and find on the second tab called “AMR wTran Code”. When it finds the trancode, I want it to return the value in Column A of that line to the Data tab, Column E titled "Access Model". So the answer for this one would be “AM_ICS_TC_PAN_0016_UPD”. I want to create the formula on the “Data” tab in the E Column titled “Access Model”. Also, be aware, that I am still building the Data Tab, so a lot of them will not have matches yet. I have been trying to use Vlookup, but it hasn’t worked and then have found tutorials on MATCH and INDEX. I’ve tried using these and I can’t get a formula to work, but I am thinking one of them should. Any ideas?