lookup or autofilter display results on another sheet

jinx_uk_98

Board Regular
Joined
Jul 3, 2005
Messages
105
I have a sheet called 'source' on which I have 365 rows (1 of each day).

On another sheet I want to show all the data for any particlaur day which will be looked up from a cell value, almost like an auto filter but on another sheet.

Is there any way I can do this?

many thanks
Kevin
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
jinx_uk_98 said:
I have a sheet called 'source' on which I have 365 rows (1 of each day).

On another sheet I want to show all the data for any particlaur day which will be looked up from a cell value, almost like an auto filter but on another sheet.

Is there any way I can do this?

many thanks
Kevin

See if the following setup applies to your situation:

http://www.mrexcel.com/board2/viewtopic.php?t=146895
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,403
Assuming that Source!A1:D365 contains your data, enter on another sheet the lookup value/day of interest in A1, enter the following formula in B1, and copy across:

=INDEX(Source!B$1:B$365,MATCH($A1,Source!$A$1:$A$365,0))

Adjust the ranges accordingly. Is this what you're looking for?
 

Watch MrExcel Video

Forum statistics

Threads
1,119,130
Messages
5,576,270
Members
412,710
Latest member
Maged elmasry
Top