Report

Matching 2 values from one spreadsheet [Solved]

Ask a question sargiesan59 3Posts Saturday July 16, 2016Registration date July 16, 2016 Last seen - Last answered 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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!