Forum Discussion

elmai735's avatar
elmai735
Copper Contributor
Feb 02, 2022

IF formula with multiple conditions

Hey guys, 

I'm definitely not good at this and would need some kind help from you.

 

Is there a formula that says:

IF column F has name (MARIO) and column N has the value (0 - 84.9%) then column N will need to be (0.12).

 

The value in brackets will change.

Also, if possible, I would like that the value displayed in column N is taken from a table that would be in another tab of the same sheet.

 

Thanks a lot for helping! 

Formulas and Functions

7 Replies

Sort By
    • elmai735's avatar
      elmai735
      Copper Contributor
      Feb 02, 2022
      it's just a text value. I will have to use the following:
      0 - 84.9%
      85 - 94.9%
      95 - 99.9%
      100%
      Repetition
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Feb 02, 2022

        elmai735 

        Create a lookup table like this, on a sheet named (for example) List:

        On the other sheet, enter the following formula in row 2 in the column where you want to return the result:

        =IF(F2="Mario", IFERROR(VLOOKUP(N2, List!$A$1:$B$5, 2, FALSE), ""), "")

        This can be filled down.

Resources