Combine two IF statements

[JayReddy]

Hi All,

Some assistance please

I am trying to combine two IF statements that work fine singularly. I'd like to do this using a formula and not VBA if possible.

=IF(C10= "Vendor Approver", "Approval Level","")

and

=IF(C10= "Vendor Requestor", "Requestor Level","")

Should I be using IF+AND/OR?

Thanks in advance,

Regards, Jay

 

[SpillerBD]

=IF(C10= "Vendor Approver", "Approval Level",IF(C10= "Vendor Requestor", "Requestor Level",""))
In this mode it works like If Then... Else...

 

[JayReddy]

Hi SpillerBD,

Thank you so much for the prompt reply! This works perfectly! Very much appreciated!

 

[njimack]

Either of these would also work for you:
=LOOKUP(C10,{"Vendor Approver","Vendor Requestor"},{"Approval Level","Requestor Level"})
=SUBSTITUTE(SUBSTITUTE(C10,"Vendor ",""),"er","al")&" Level"