I wonder if someone can help me please?
I want to update a separate sheet/ tab within an overall google sheet based on the entries in another sheet / tab and the date selected so for example
Sheet 1 has the data such as
31 May Name Emails Allocated Emails Completed Emails Remaining
James 100 50 50
01 Jun Julia 120 20 100
02 Jun John 80 40 40
On Sheet 2 I want to be able to select the date and it will populate that sheet with the above information from Sheet 1 based on the date I've selected.
So if I select 01 Jun it will update with data for Julia and if I select 02 Jun it will update with data for John and so on.
How can I do this please?
Kind regards
Chris
CodePudding user response：
On sheet2, try
=offset('Copy of Copy of Direct Sales '!$A$1,MATCH($B$1,'Copy of Copy of Direct Sales '!A:A,0)-1,1)
other solution with unique formula
=arrayformula(vlookup(B1,'Copy of Copy of Direct Sales '!A:L,{2;3;4;5;6;11;12},0))
CodePudding user response：
Thanks again Mike, your formula was perfect.