I have a table with old id numbers that I would like translated into new id numbers when input. For example old id number 1 is now 80550104. I would like for the user to be able to input the old id into a cell (in column old id) and have it check the table and fill the cell in column new id. So if old id is column F and new id is column G when I input 1 into F2 it fills G2 with 80550104, and F3 fills G3 so on. Can anyone help with how this can be done? Thank you