Trying to create a grid type spreadsheet

J

JHL

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.
I’ve tried Vlookup & If statements, but I’m missing something. Can someone
offer a solution?

Thanks.
 

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

Similar Threads

IF function 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
SUMIFS help 3
Eliminate Duplicate Entries in Order to Create Labels Using Mail M 3
Trying to create custom labels from an csv file + Need items numerically counted out 0
Difficulty with Sum+IF Function 10
Count Uniques with a Couple Conditions 2
Search a cell for a specific number 5

Top