Forum Discussion
EXCEL: "If cell contains specific letter using LEFT formula then return specific text"
Problem: 25k rows per column and I'm trying to extract different types of product references. Using =Left(cell;1) I will have 3 different outputs. "E", "F" and "U". Now what I need to do is ren...
Try this:
=IFERROR(CHOOSE(MATCH(LEFT(B5),
{“E”,”F”,”U”},0),
“TextForE”,”TextForF”,TextForU”),
LEFT(B5))
=IFERROR(CHOOSE(MATCH(LEFT(B5),
{“E”,”F”,”U”},0),
“TextForE”,”TextForF”,TextForU”),
LEFT(B5))