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
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