Forum Discussion

John Bebb's avatar
John Bebb
Copper Contributor
Oct 14, 2016
Solved

Look up to match dates and data

In one workbook I have several induvial data sheets and one “Master” sheet. Col A of the Master sheet lists > 1 year of Date & Time in 5 minute contiguous steps. Each data sheet has Col C a...
excel
Formulas and Functions
Macros and VBA
  • JohnnieThomas's avatar
    JohnnieThomas
    Oct 25, 2016

    I agree with Olaf's suggestion you can use the MATCH formula to find Rows on your Data Sheet where there are time stamp matches.  You can use the Index formula to grab a value from your Data columns.

     

    Combine them and you get the type of lookup it sounds like you need

     

    the psudeo formula is:

     

    =INDEX(Data Column in Data Sheet, MATCH(Time Stamp in Master Sheet Timestamp Column, TimeStamp Column in Data Sheet, 0))....the zero means look for exact matches

     

    Given the layout of your data you could also the VLOOKUP formula, but the INDEX/MATCH combination runs faster and is a valuable, versitile function combo to learn.

JohnnieThomas's avatar
JohnnieThomas
Icon for Microsoft rankMicrosoft
Oct 25, 2016

I agree with Olaf's suggestion you can use the MATCH formula to find Rows on your Data Sheet where there are time stamp matches.  You can use the Index formula to grab a value from your Data columns.

 

Combine them and you get the type of lookup it sounds like you need

 

the psudeo formula is:

 

=INDEX(Data Column in Data Sheet, MATCH(Time Stamp in Master Sheet Timestamp Column, TimeStamp Column in Data Sheet, 0))....the zero means look for exact matches

 

Given the layout of your data you could also the VLOOKUP formula, but the INDEX/MATCH combination runs faster and is a valuable, versitile function combo to learn.

Resources