Hello,

I'm trying to create a formula so that when a certain value in one column is present, I can automatically pull through another value - both values being text. I've used the =IF formula which works great, but I'm looking to do more than 64 values, so it's bringing up the nesting limit error. Is there another way to do this?

For example, say I have the value 'Banana' in cell A2 and I want to assign the value 'Yellow' to it in cell B2. The IF formula I was using before discovering the nesting limit was:

=IF(A2="Banana","Yellow",IF(A2="Strawberries","Red",IF(A2="Lime","Green")))

I'm then dragging the formula down the B column to check all of the values in the A column and assign them the relevant value. Hopefully this makes sense.

Thank you in advance for your help

Ally