Excel Pooh
New Member
- Joined
- Jul 20, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Good afternoon friends, I am calling on your wisdom yet again. I have an IF formula that pulls a text string from a referenced cell, but I would like it to only show the last word. Right now it may pull "Los Angeles Millwork" or "Texas Truss" or the like, I would like it to only display "Millwork" or "Truss". I have been able to do this inside more simple formulas in the past, but am not sure how to apply it to my current formula. ANy ideas how I could adjust the below to only show the last word? Thanks in advance!
=IFERROR(IF(INDIRECT("'"&$Q$1&"'!E3")="Home",INDIRECT("'"&$Q$1&"'!C3"),INDIRECT("'"&$Q$1&"'!A3")),"-")
=IFERROR(IF(INDIRECT("'"&$Q$1&"'!E3")="Home",INDIRECT("'"&$Q$1&"'!C3"),INDIRECT("'"&$Q$1&"'!A3")),"-")