Help with formulas using contact list
I am trying to create an "Assigned To" sheet for each employee. I would like to pull from a contact list column on another page. I want it to return "Alex" if Alex is listed in the column and reference "Job"@row, if column has other names or blank, I would like it to return blank. Is this possible?
On empty sheet (Assigned To),
I need Job 1505 to show "blank" and 1506 to show "Alex" in Route 1 Assigned To column
and pull the info from the full sheet (Job List)
I would like to use MATCH([Job]@row so I can copy and paste all the way down the column.