Good day! Is it possible in excel to show the table in sheet 2 to sheet 1 based on the drop down value? If I will change the drop down value, then the table will change. Should I use VLOOKUP for that or there's something else that I should use?
Good day! Is it possible in excel to show the table in sheet 2 to sheet 1 based on the drop down value? If I will change the drop down value, then the table will change. Should I use VLOOKUP for that or there's something else that I should use?
Let each table be a named range:
grade_1 =Sheet2!$H$3:$I$6
JUNIOR_KINDER =Sheet2!$B$3:$C$5
SENIOR_KINDER =Sheet2!$E$3:$F$5
In B4, refer to the named ranges by replacing the spaces in the dropdown list with "_":
In B5:Please Login or Register to view this content.
copied across and down.Please Login or Register to view this content.
Ben Van Johnson
It worked! Thank you!
I already figured it out! My mistake is that I refer the cell into a wrong one. Anyway, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks