How to create a formula

I have an excel spread sheet that has a column with either b, g or r
I would like to create a formula in a separate column which will convert this to either Blue, Green or red

Gordon
Gordon HughesDirectorAsked:
Who is Participating?
 
Rgonzo1971Commented:
shorter
=HLOOKUP(A1,{"b","g","r";"Blue","Green","Red"},2)

Open in new window

0
 
Rgonzo1971Commented:
Hi,

pls try
=INDEX({"Blue";"Green";"Red"},MATCH(A1,{"b";"g";"r"},0))

Open in new window

Regards
0
 
Gordon HughesDirectorAuthor Commented:
ALL WORKS GREAT
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.