Methods to pull data from another sheet using drop down list
Hi.
I am doing a spreadsheet where I have 1 main sheet and 2 sheets with data.On the main sheet I have a drop down list to select either one of the 2 sheets and upon selecting,all the data from that selected sheet will be displayed on the main sheet.
Being a noob,I still cannot understand how to go abt doing it.There was an example given to me but I cannot understand how does the code work(attached Govt Non Govt.xls)
What i do not understand is the code to draw data:=IF($C$7='A2'!$A$2,INDEX('A2'!$A$6:$B$20,ROW( $A3),COLUMN(B$1)),INDEX('A1'!$A$6:$B$20,ROW($A3),C OLUMN(B$1)))
I am thinking of using vlookup..but the tutorials I seen online are calling from the same sheet itself.Can anyone help?Thanks
|