Hi.

I’m a teacher, and I’m trying to create a marking assessment sheet, in which if I select a Level from a drop down menu, it will display the relevant information.

I’ve looked at lots of functions, but have really struggled to find anything that works.

Basically, my mark scheme has 3 columns (grids) and within each column, there are 5 levels, which each have different information. What I want to happen is that as soon as a user selects the level from a grid, it displays the information from the mark scheme in the cell underneath (see picture underneath, I couldn’t fit all of the data in the print screen). I can’t use IF, as there are more than two levels and I’ve tried using VLOOKUP to no avail. Can anyone help? The file is attached.

​Hi. I’m a teacher, and I’m trying to create a marking assessment sheet, in which if I select a Level from a drop down menu, it will display the relevant information.I’ve looked at lots of functions, but have really struggled to find anything that works. Basically, my mark scheme has 3 columns (grids) and within each column, there are 5 levels, which each have different information. What I want to happen is that as soon as a user selects the level from a grid, it displays the information from the mark scheme in the cell underneath (see picture underneath, I couldn’t fit all of the data in the print screen). I can’t use IF, as there are more than two levels and I’ve tried using VLOOKUP to no avail. Can anyone help? The file is attached.     Read More

​