I have a formula that looks up a project id and returns values "very high", "high", medium, low.
I want the formula to look up the project id and when the value is Very High, display VH in the cell instead of Very High, H instead of High, M instead of Medium and L instead of L. Is that possible all in one formula?
=IF(VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,18)="",VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,21),VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,18)
I want the formula to look up the project id and when the value is Very High, display VH in the cell instead of Very High, H instead of High, M instead of Medium and L instead of L. Is that possible all in one formula?
=IF(VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,18)="",VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,21),VLOOKUP('Template'!$E7,PM!$A$2:$AD$16000,18)