Previous Topic Next Topic

Matching 2 values from one spreadsheet

Solved/Closed
sargiesan59 Posts 3 Registration date Saturday July 16, 2016 Status Member Last seen July 16, 2016 - Jul 16, 2016 at 12:48 PM
sargiesan59 Posts 3 Registration date Saturday July 16, 2016 Status Member Last seen July 16, 2016 - Jul 16, 2016 at 05:03 PM
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

Related:

2 responses

Answer 1 / 2
sargiesan59 Posts 3 Registration date Saturday July 16, 2016 Status Member Last seen July 16, 2016
Jul 16, 2016 at 12:52 PM
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
0
Answer 2 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jul 16, 2016 at 03:44 PM
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
0
sargiesan59 Posts 3 Registration date Saturday July 16, 2016 Status Member Last seen July 16, 2016
Jul 16, 2016 at 05:03 PM
Perfect..worked exactly as i needed..
thanks for your help
0