I need to add "text" to the beginning of an IF(Index/Match) result. Is there a way to do this?
This is my current IF(Index/Match) formula:
=IF(B20="","",INDEX('Depts & Codes'!$D$20:$D$33,MATCH(B20,'Depts & Codes'!$B$20:$B$33,0)))
If the result of this formula is (let's say) 20 - I would like it to display as "Cost Code 20" (without the quotations) on my spreadsheet, but if the result is blank/nothing, I want the cell to be blank.
I can easily achieve this by having "Code Code" in the cell immediately preceding the result cell ... BUT, I am totaling my columns (which include the rows that this formula exists) and thus the result is included in my totals (which it shouldn't).
Any suggestions? Thanks so much!
P.S. I can also achieve my desired result by adding "Cost Code" before the "Index" result in my 'Depts & Codes' list, but would prefer to not have to do this.
Bookmarks