kalyanverma
New Member
- Joined
- Mar 28, 2007
- Messages
- 2
Hello All,
Attached is an example. Is there a way we can achieve this without using auto filter and macros? i.e when i enter the date in cell A1, it should lookup from the range B2:D20 and show all the rows for that date in the range F2:H20.
Download XLS here: http://www.excelforum.com/attachmen...78-multiple-lookup-function-excelquestion.xls
I hope i was understandable.
Regards
Attached is an example. Is there a way we can achieve this without using auto filter and macros? i.e when i enter the date in cell A1, it should lookup from the range B2:D20 and show all the rows for that date in the range F2:H20.
Download XLS here: http://www.excelforum.com/attachmen...78-multiple-lookup-function-excelquestion.xls
I hope i was understandable.
Regards