Forum Discussion
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 ...
HelloThorkild1991
If you're using Office 365 or Microsoft Office 2019 version, you can easily deploy the IFS function which will handle multiple nested IF statement in older versions.
See an example of the IFS function in the attached caption
