Nested IF x50

[karlitob]

Hi all,

Since learning about IF functions, I was successful in writing a nested IF changing 50 values for a different (but similar) 50 values.

Is there a better way that you could direct me to research please.
Thank you.

 

[Michael M]

You might need to give us a bit more information.....!!

 

[Scott Huish]

Without much else to go on, I would suggest looking at the VLOOKUP function.