Lookup range to find name, return specific text if cell contains the name

0
votes

trying to write a formula that will lookup a range based on text in column A and return what the person is working on. For example, I want the formula to look at cell A1 (John), and find if John exists in the range. If he does, then I want it to return what he's working on (Deep Fry Station). Or if it's Wayne, I want it to return "Packer".

enter image description here

1
excelexcel-formula
What have you tried? What are your results? – Ron Rosenfeld
Please put the data as text in the Original Post using EDIT so we do not need to recreate the data. – Scott Craner

1 Answers

2
votes

Use TRIM, MID, SUBSTITUTE and REPT to retrieve the 'piece' that you want with wrapping IFERRORs to compensate for no matches.

enter image description here