Multiple "IF" problems

[COZWV]

I am trying to create a formula that will allow 2 different results. (Formula in F3)

=IF(F5="E-1565",'LNL ROSTER'!C43) <------ it works just fine this way. but I want to also have it include this: =IF(F5="E-2504",'LNL ROSTER'!C44)

(Basically if the operator types in the badge # of "E-2504" in cell F5 I want it to put the guys name (which comes from the "LNL Roster" sheet) in cell F3.)

=IF(F5="E-1565",'LNL ROSTER'!C43)=IF(F5="E-2504",'LNL ROSTER'!C44)

Should I even be using "IF" for multiple possible answers based on multiple possible badge numbers? I only have two different badge numbers right now.

[NBVC]

Probably Vlookup would be best suited...

=Vlookup(F5,'LNL ROSTER'!$B$43:$C$44,2,FALSE)

where 'LNL ROSTER'!B43:C44 contains a list of badges and associated names...

adjust ranges to suit.