Quote:
Originally Posted by monkeyman
=IF(A1="Red", "R",(IF(A1="Green","G",(IF(A1="Blue", "B","NULL")))))
you can also assign values to colours and use a vlookup.
I'm sure there's other ways as well. I'd be interested in how other posters would do it differently.
|
For the Red, Green, Blue example what you have would be the simplest I think. Anything I used to use vlookup for I now IndexMatch, it's much more versatile and can lookup backwards.