Looking up information using two columns

[mark hansen]

I have a data set with the persons name in AD and the Date in AE - along with other data I will be pulling. Each date the users will be sending data on what they did that day. So in the data set, column AD will have the user's name listed more than once. As more than one users will be sending data each day, the date will appear more than one time. There should only be one line with a specific user on a specific date.

In a report, I have the user name going down the side and the dates across the top. Normally I would use index, match to find the data I need, but both of the information I use to look up in in column, not row and column.

Any thoughts on how I would find the correct row by using the user name and date?

Thanks for any insight.
Mark

 

[JoeMo]

Maybe something like this:

Excel Workbook
	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1		6/1/2019	6/2/2019	6/3/2019	6/4/2019	6/5/2019	6/6/2019	6/7/2019	6/8/2019				User Name	Date	Task
2	Joe						A						Joe	6/6/2019	A
3	Tom						B						Tom	6/6/2019	B
4	Jane		C										Jane	6/2/2019	C
5	Jill			D									Jill	6/3/2019	D
Sheet3

 

[mark hansen]

Thanks Joe... I incorporate this formula. I appreciate the help!!

Mark

 

[JoeMo]

Thanks Joe... I incorporate this formula. I appreciate the help!!

Mark

You are welcome - thanks for the reply.