Report

Matching 2 values from one spreadsheet [Solved]

Ask a question sargiesan59 3Posts Saturday July 16, 2016Registration date July 16, 2016 Last seen - Latest answer on Jul 16, 2016 05:03PM
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
See more 
Helpful
+0
moins plus
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
Add comment
Helpful
+0
moins plus
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 3Posts Saturday July 16, 2016Registration date July 16, 2016 Last seen - Jul 16, 2016 05:03PM
Perfect..worked exactly as i needed..
thanks for your help
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!