Help with Vlookup with nested if OR

[STIRRELL]

Please help, I need a vlookup up that if its one of 2 department numbers to look up by ID else lookup by department number. My attempt below.
=IF(OR(B2=7,B2=9),VLOOKUP(Sheet1!A2,LOOKUP!$D$2:$E$9,2,VLOOKUP(Sheet1!B2,LOOKUP!$A$2:$B$10,2,0)))
thank you for your help,
Sharon

 

[Oeldere]

=IF(OR(B2=7,B2=9),VLOOKUP(Sheet1!A2,LOOKUP!$D$2:$E$9,2,[COLOR=#ff0000]0),[/COLOR]VLOOKUP(Sheet1!B2,LOOKUP!$A$2:$B$10,2,0))

Should it not be this one?

Or what is the question?

 

[STIRRELL]

=IF(OR(B2=7,B2=9),VLOOKUP(Sheet1!A2,LOOKUP!$D$2:$E$9,2,[COLOR=#ff0000]0),[/COLOR]VLOOKUP(Sheet1!B2,LOOKUP!$A$2:$B$10,2,0))

Should it not be this one?

Or what is the question?

thank you perfect