Hi Avii, In my earlier post, I was trying to put the table in below format so it make sense. You can use this formula in any tab where you want to see the name and change the reference cell in formula, it will populate the Agent Name you are looking for. Hope this helps. Formula in D3 =IFERROR(VLOOKUP(C3,A:B,2,FALSE),"")