Forum Discussion

Thorkild1991's avatar
Thorkild1991
Copper Contributor
Oct 18, 2019

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 ...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Oct 18, 2019

Thorkild1991 

In D2, you can enter a formula like: 

=LOOKUP)C2,A$2:B$4)

Note that ID's are in A2:A4 and Names are in B2:B4. 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Oct 18, 2019
      Modify your formula to this:
      =IF(ISNUMBER(C6)*(C6>2),
      C6,
      “S”)

Resources