Is it possible to create an if-command from a table?

Let's say I have a table like this: ID Name 1 James 2 David 3 Jackie   I want to have a cell (A4) show me the name of a person based on their ID number shown in ...