Hello everyone, good evening!
I have a table on wich I organize the tasks assigned to a given fleet of vehicles during the day. For example, vehicle 100 will perform the tasks "S32", "SW3" and "NE32". These are random names, no speacial meaning on any of them.
On the right, on range L2:M3 I have a little "search box" on wich I insert a task name on M2, and I need a formula on M3 that returns the vehicle that is performing that task. For example, if I write "S10" on M2, M3 should display "102", meaning that vehicle 102 is performing task "S10".
Could anyone shed some light on this one?
Best regards,
V
I have a table on wich I organize the tasks assigned to a given fleet of vehicles during the day. For example, vehicle 100 will perform the tasks "S32", "SW3" and "NE32". These are random names, no speacial meaning on any of them.
On the right, on range L2:M3 I have a little "search box" on wich I insert a task name on M2, and I need a formula on M3 that returns the vehicle that is performing that task. For example, if I write "S10" on M2, M3 should display "102", meaning that vehicle 102 is performing task "S10".
Could anyone shed some light on this one?
Best regards,
V