Forum Discussion
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 as Date & Time in 5 minute stamps which are sequential but not necessarily contiguous, Cols AS & AT may contain “results” for the respective sheet Col C Date & Time.
I wish to procure a lookup formula which will place each data sheets AS & AT data into new columns in the Master where the Date & Time stamps match.
Thank you, Bebbspoke
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
Microsoft
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.
