Looking up information using two columns

mark hansen

Well-known Member
Joined
Mar 6, 2006
Messages
534
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Maybe something like this:
Excel Workbook
RSTUVWXYZAAABACADAEAF
16/1/20196/2/20196/3/20196/4/20196/5/20196/6/20196/7/20196/8/2019User NameDateTask
2Joe AJoe6/6/2019A
3TomBTom6/6/2019B
4JaneCJane6/2/2019C
5JillDJill6/3/2019D
Sheet3
 
Upvote 0
Thanks Joe... I incorporate this formula. I appreciate the help!!

Mark
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top