Formula Help

  • Thread starter Thread starter Ladypep
  • Start date Start date
L

Ladypep

I'm doing a formula to where I have to convert one text
character to another, and it works fine. Using an IF
Statement to do it. However, I also need the formula to
return a blank if the cell I'm creating the formula based
on is blank. Below is the current formula:

=IF(D7="E", "A", IF(D7="I", "B", IF(D7="U", "C", IF
(D7="N", "D", IF(D7="A", "A", IF(D7="B", "B", IF
(D7="C", "C", IF(D7="D", "D"))))))))

This formula returns the correct results. However, I need
it to return a blank if Cell D7 is blank.
 
Try:

=IF(D7="","",VLOOKUP(D7,
{"E","A";"I","B";"U","C";"N","D";"A","A";"B","B";"C","C";"D
","D"},2,0))

HTH
Jason
Atlanta, GA
 
Another option:

=MID(" ABCDABCD",SEARCH(D7," EIUNABCD"),1)

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Back
Top