This is a tough one !

[kaseyleigh]

I have ranges of criteria (27 of them!) I need to replace with another name, I could use the IF function but this only allows 7 nested statements, therefore, needing to use 4 cells all linking to the previous in order to do this. This also makes it a headache when trying to adjust the ranges!!

Anyone got brilliant ideas how to solve my problem?!

I was hoping for a nice laid out table that I could type into and it linked somehow .... Ihave reached a dead end.

Please help.
Ta
Kasey

 

[Oaktree]

Welcome to the board.

Maybe a VLOOKUP?

 

[Richard Schollar]

Hi Kasey

Welcome to the Board!

Almost certainly you can use a lookup of one flavour or another - please can you provide exact details of what your criteria are and how and to what they are applied.

Thanks

Richard