Hi Amit,
Follow steps carefully in sequence
Add 3 named ranges as below
Vehicle=LOG!$E$2:INDEX(LOG!$E$2:$E$1,MATCH(REPT(z,20),LOG!$E$2:$E$1,1))
EntryDate=LOG!$B$2:INDEX(LOG!$B$2:$B$1,MATCH(9E+305,LOG!$B$2:$B$1,1))
Data=IF((EntryDate=Sheet2!$A1)*(EntryDate=Sheet2!$B1)=1,Vehicle,)
Dear Sam,
Thanks for the detailed explanation but I could not understand the range
Data - how to create a range. I have selected data set in for Vehicle
EntryDate created data range for the same. But could not move further since
I could not create Data range.
And yes, thanks a lot for
Amit, please go to Names Manager, and give the name of the range as Data,
and use the formula that I provided below. To go to Name Manager using a
short-cut key, hit CTRL+F3
Post back if you need more help.
Regards,
Sam Mathai Chacko (GL)
On Mon, Oct 3, 2011 at 12:10 AM, Amit Desai (MERU)