Macro for look up required.

[chippymark]

Not sure if any one can help but I am in need of a macro / formula to help achieve the following:

in cells c2 > c20 I have various names
in cells c3? c20 I have a number below each name.

These names all appear in colum A5 > A25

Now what I would like is if in C3 i have the figure 10 I want to look for the same name in Column A and have 10 crosses in the corresponding row.

Hope I am makeing sense ?

so if C2 = Mark & C3 = 5 then A5 (which is Mark) would have and 'X' in B5, C5, D5, E5, F5

Many thanks is advance

Mark

 

[chippymark]

Not sure I worded correcly see below see if this helps as an example:

Mark Fred John Pete
5 2 7 1


Mark x x x x x
Fred x x
John x x x x x x x
Pete x

 

[Gerald Higgins]

Assuming that
1) the names Mark, F, J and P are in the ranges C2:F2, and ALSO in A5:A8
2) the numbers 5, 2, 7, 1 are in the range C3:F3
3) it is POSSIBLE that there may be names in A5:A8 that do not appear in C2:F2

In B5

=IF(ISERROR(HLOOKUP($A5,$C$2:$F$3,2,0)),"",
IF(HLOOKUP($A5,$C$2:$F$3,2,0)>0,"X",""))

In C5

=IF(ISERROR(HLOOKUP($A5,$C$2:$F$3,2,0)),"",
IF(HLOOKUP($A5,$C$2:$F$3,2,0)>COUNTIF($B5:B5,"X"),"X",""))

Copy this formula as far to the right as necessary.

Then copy both formulas down as far as necessary.