Use text in one cell to fill in information in other cells in same row (ex. attached)

First, i separated your data in Col X into separate columns.

In Q2, dragged across and down.
=HLOOKUP($A2,$X$4:$Z$8,COLUMN(B1),FALSE)
See attachment.
Is that what you are looking for?

Originally Posted by ChemistB

First, i separated your data in Col X into separate columns.

In Q2, dragged across and down.
=HLOOKUP($A2,$X$4:$Z$8,COLUMN(B1),FALSE)
See attachment.
Is that what you are looking for?

Yes, that definitely gets me the result I want, but I don't understand how you got the "COLUMN(B1), FALSE" . I'm having trouble re-creating it in my spreadsheet. Maybe it's because I don't understand what you mean when you say, " separated data in Col X into separate columns". It looks exactly the same as the original when I opened the file.

UPDATE: Okay, I did a little research and figured out that's the way to advance through the rows. It's working now exactly the way I need. Thanks so much for your help.

In your original uploaded file, if you click on X4 (for example), you'll see that cell contains "AMATTHEW BTHOMPSO CMCDONAL". If you open up my spreadsheet, you'll see that x4 contains AMATTHEW, Y4 contains BTHOMSO, and Z4 contains CMCDONAL
Is your data being imported from somewhere else?

Here's a link that explains how HLOOKUP works
http://www.techonthenet.com/excel/formulas/hlookup.php
I used COLUMN(B1) instead of a constant like 2 so that when I copy a formula to the right, that value will change. Column(C1) = 3, COLUMN(D1) =4 and so on.
Let me know if you still have questions after reading the link.