Vlookup or Index/Match

F

Fred

I have a worksheet of data (cells named PV_Data), extracted from a d/
b, column A contains a "week commencing" date (cells named "Week_Of")
and column B contains a list of names (cells named "Resources"). I
have a second worksheet that I am trying to populate based upon the
contents of the first sheet. In this worksheet, Column A contains the
list of names I am looking for, Column B, C, D, E and F are labeled/
column headers with the Week Commencing dates, to be found in the
first worksheet. What I want to do is put an x in the appropriate
column when I find the name in the second worksheet
Sheet 1
01/04/2008 Fred
01/04/2008 Jim
07/04/2008 Jim
07/04/2008 Joe
14/04/2008 Fred
14/04/2008 Jim
14/04/2008 Joe
21/04/2008 Jim
21/04/2008 Joe

Sheet 2
Names 01/04/2008 07/04/2008 14/04/2008 21/04/2008 .....
Fred X X
Jim X X
X X
John
Joe X
X X

I believe I need to use Index and Match, but I can't seem to get
beyond the #N/A result

Any suggestion gratefully received
Fred
 
D

Dave Peterson

Have you thought of adding headers and then creating a pivottable?

Drag the header for the date to the column field.
Drag the header for the name to the row field.
and drag the name header to the data field.

You'll see a count of names instead of an X, but you could select the
pivottable, copy|paste special|values and then do a couple of edit|replaces to
change the 1's to X's (if you really wanted them).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top