Forum Discussion
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 ...
thanks HansVogelaar ! it doesn't seem to work though, no error, just empty result 😞
Could you please also show me the simple version without the Vlookup in case I want to add the table on the same sheet?
thanks so much for helping!
It would work the same with the table on the same sheet. Here is my test workbook.
You originally mentioned that the breakdown was in column N, so the formula looks at column N.
The breakdown is now in column L, so you should change N2 to L2.