VLookup/Index/Columns to rows

[Frogger0102]

Please see the attached example that shows exactly what I am looking for.

Thanks

[ChemistB]

First, you'll need to insert a new column in Sheet2, Column C where C2 =A2&B2, dragged down. You can hide that column if you like.

Next, some of your names on Sheet1 col A have spaces after them. Get rid of them or you won't get matches.

In Sheet1!B2, dragged across and down

Please Login or Register  to view this content.

Does that work for you?

Alternately, if you don't want to remove those spaces in Col A sheet1,

Please Login or Register  to view this content.

[Frogger0102]

This is great. Thanks!