CODEWITHSUNDEEP
excelexcel-formulaexcel-2010excel-2007
user1932747
user1932747

Reputation: 41

A Lookup of ALL values that match a Date

I'm trying to create a sheet that looks through 3 other sheets and combines only the data from all 3 that match today's date.

So if these are my sheets

Data 1:
x              y
7/8/2016       Bananas
7/7/2016       Apples

Data 2
x              y
7/8/2016       Oranges
7/7/2016       Grapes

Data 3
x              y
7/8/2016       Pineapple
7/7/2016       Grapefruit

And I need a formula that returns the following result

x
Bananas
Oranges
Pineapple

Upvotes: 0

Views: 243

Answers (1)

Ralph
Ralph

Reputation: 9434

Replace Bananas with

=INDEX('Data 1'!B:B,MATCH(Today(),'Data 1'!A:A,0))

Replace Oranges with

=INDEX('Data 2'!B:B,MATCH(Today(),'Data 2'!A:A,0))

and instead of Pineapple you should use

=INDEX('Data 3'!B:B,MATCH(Today(),'Data 3'!A:A,0))

All of the above assumes that the date is in column A of the sheets while the fruits are in column B.

Updated the functions with Today() thanks to @ForwardEd.

Upvotes: 1

Related Questions