Filtering/Vlookup By Date...

[santeria]

Currently I have a test Vlookup set for Lookup by Person, which is indexed Numerically, and this then Brings up a Set of "Issues" related to the Person.

Into this Mix is thrown the added lookup of a Date Value, so is it possible to add another vlookup ( or whatever formula is necessary) which will in turn modify the Name, and the Subsequent Issues.

Below is what I have now.

Is a Date Lookup or Indexing of People related to variable dates possible?

AL Feb. Call Quality.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
33	DATE	NAME					SKILLELEMENTSMISSED
34		1
35		RakesSJoseph					Preparedness,CallGreeting,AccountVerification
February 2-6

Ta Muchly

 

[just_jon]

A few more details -- is it that you are wanting to return comments associated with A] a given person/ID number but restricted to, B] a certain date or date range? If so, in what column do the dates reside?

 

[santeria]

Ideally if I can filter the name and the subsequent comments by Date.

At this stage the Date Value is not in the Names Area.
It may be before or After the Name, not clear from Current Data yet.

Still working on it.

Ta