Hello and Happy New Year to you from snowy Bolton! Am hoping someone can help with this (example attached). I need a formula that will look at cell B9 and depending on whether it is saying Category 1, 2 or 3 will then take the corresponding data from cells G:I (whichever column category is relevant) and put that data into the corresponding cell in column C.
I know it's an if/then something but can't get my head around it.
All help as usual very much appreciated!
Bookmarks