Trying to create a grid type spreadsheet
 

Trying to create a grid
I am using Excel97. I want to create a grid type spreadsheet see below

I thought I could post a picture type here of my example

colA are the dBase names (contains duplicates), colB are the fieldnames
(contains duplicates), colC are the field names without duplicates.

ColD thru G reference the dBase names in the row

I want to place an €˜x per the example without the duplication. See the
shaded areas.
Ive tried Vlookup & If statements, but Im missing something. Can someone
offer a solution?

Thanks.