create worksheet report with dates and number

[Juleew]

I am creating a report that shows if a number was recorded on a specific date. The report will list the numbers (column A) and will insert an X on each day of the month (Row 1 across) if that number was recorded for that day. I am using range names. I haven't written formulas in many years so I am a little dusty on this. I think it is nested VLOOKUP but just can't see how to do it. I couldn't get the Mr Excel HTML maker addin to work so I have to "old school" it and show what I tried to explain.

worksheet with the data recorded
range btn_date_aug is the date of reported number
range btn_num_aug is the number reported

A B
1 date num
2 8/2 2356
3 8/2 298d
4 8/3 2356
5 8/3 457g


report worksheet layout
A B C D ....
1 NUM 8/1 8/2 8/3
2 2356 X X
3 457s
4 457g X
5 298d X

Thanks!

 

[Juleew]

I tried to edit the report but it wouldn't allow me to save it but...

Report worksheet layout
[TABLE="class: grid, width: 60"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NUM[/TD]
[TD]8/2[/TD]
[TD]8/3[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2356[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]298d[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]457g[/TD]
[TD][/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Juleew]

ok so I got this far but stuck. It is putting an X in the cell no matter what...sigh
=IF(ISERROR(VLOOKUP($A3,Bnt_tail_aug,1,FALSE)),"",IF(ISERROR(VLOOKUP(I$1,Bnt_date_aug,1,FALSE)),"","X"))