Mark Horsfall
Member
Hello
I think I need a vlookup formula for this to work but I might be wrong.
I have attached a spreadsheet to show you what I am looking for
F3 is a dropdown box with Test A, Test B, Test C
Upon choosing from the drop down box I want the pupils percentage for that test to show up
If I choose Test A in F3 in sheet 1 I want the data from sheet 2 B2 to display the percentage for Test A
If I choose Test B in F3 in sheet 1 I want the data from sheet 2 D2
If I choose Test C in F3 in sheet 1 I want the data from sheet 2 F2
Mark
I think I need a vlookup formula for this to work but I might be wrong.
I have attached a spreadsheet to show you what I am looking for
F3 is a dropdown box with Test A, Test B, Test C
Upon choosing from the drop down box I want the pupils percentage for that test to show up
If I choose Test A in F3 in sheet 1 I want the data from sheet 2 B2 to display the percentage for Test A
If I choose Test B in F3 in sheet 1 I want the data from sheet 2 D2
If I choose Test C in F3 in sheet 1 I want the data from sheet 2 F2
Mark