Hi all
Thanks in advance for any feedback - much appreciated
Please see attached document
Using Pupil A as example
I have added a vlookup to I4 which will lookup different tables (highlighted yellow) in the different grades sheet based on whether C4 equals A or B
Id like to add another layer.
C1 has the number 1 in it- id like to be able to change this to a 2 and have the vlookup look at a different set of tables in the different grades sheet (highlighted in blue) but still using C4 to decide which of the columns to refer too.
Ive googled and can see indirect and match may be the answer but im not entirely sure how to translate to my sheet.
Any feedback greatly received- thanks all
Bookmarks