CODEWITHSUNDEEP
excelexcel-formula
user7242409
user7242409

Reputation:

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

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

Upvotes: 0

Views: 276

Answers (1)

user4039065
user4039065

Reputation:

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

Upvotes: 2

Related Questions