HI!
Is it possible to have a formula in excel that checks if E5, F5,G5,H5,I5 are empty and if it is not then return a value for the cell that is not empty?

I have a worksheet where the person needs to mark one of those cells and I need a formula that if the marked one is E5 then return the letters EE if the marked one is F5 return LL, if the marked one is G5 return BP, if the marked one is H5 return 504 or if the marked one is I5 return D.

Can this be possible? if so how?

I HAVE TRIED THIS:


=IF(AND(SUBGRUPOS!E5="EE","EE","",SUBGRUPOS!F5="LL ","LL","",SUBGRUPOS!G5="BP","BP","",SUBGRUPOS!H5=" 504","504","",SUBGRUPOS!I5="D","D",),"")

BUT IT RETURNS A #VALUE ERROR