Matching 2 values from one spreadsheet [Solved/Closed]

Report
Posts
3
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 16, 2016
-
sargiesan59
Posts
3
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 16, 2016
-
Hello,

I have 2 spreadsheets..
first has 3 columns
id, date, time value

second
volume with id
header across of date
would like to populate the 2nd with the time value base on id & date

2 replies

Posts
3
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 16, 2016

sorry auto correct changed
the 2nd spreadsheet has
column a has the id
then a row with date
i would like to match the id & date on the 2nd with the first and fill in the time value

i can submit a spreadsheet sample
just need to know where/how

thanks
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
sargiesan59, Good afternoon.


Scenario:

Sheet 1
A1:A10 --> ID
B1:B10 --> DATE
C1:C10 --> TIME

Sheet 2
A1 --> ID
B1 --> DATE
C1 --> FORMULA

C1 --> =SUMPRODUCT((Sheet1!A1:A10=A1)*(Sheet1!B1:B10=B1)*(Sheet1!C1:C10))

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
sargiesan59
Posts
3
Registration date
Saturday July 16, 2016
Status
Member
Last seen
July 16, 2016

Perfect..worked exactly as i needed..
thanks for your help