lookup or autofilter display results on another sheet

[jinx_uk_98]

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

 

[Aladin Akyurek]

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]

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?

 

[jinx_uk_98]

excellent, thanks very much