List Vlookup assistance

[Nova1979]

Morning all
I am using the following formula to look up a list

=Ifna(if(vlookup(k2,sheet1$a$1:$b$53,2,false)=“”,””,vlookup(k2,sheet1$a$1:$b$53,2,false)),”123456”)

This enables a dropdown list on another page to input a number reference other wise return 123456.
I am now hoping to get help to add to this with a conditional component.
In the list the above formula references I have OT2 which returns a value (lets say for this 123). Is there a way to return another value for OT2 (let’s say 456) for the reference of team leader in column E?
My problem is I need OT2 in the list as it relates to an overtime type but has one number to be listed for team leader and another number for trade.

Thanks for any help in advance

 

[Nova1979]

Something I failed to mention is the the Team Leader in column E is also a dropdown (not sure if this makes a difference)

 

[Nova1979]

UPDATE:
I have basics sorted

=ifna(if(e2=“team leader”,vlookup(k2,table1,2,false),if(e2<>”team leader”,vlookup(k2,table2,2,false))),”123456”)

Now the problem I face is that some of the return cells in the tables a blank (this is required) however the belie returned based on the formula is 0. Is anyone able to help with this as I need it to return the blank cell

Thanks again in advance.