Using multiple cells on one workbook to fill answer in another workbook

Hello,

 

I have one sheet that has 100 rows.  Column A has numbers ranging from 1 – 9 (each number is used multiple times).  Column B has 100 different names.

 

I then have another sheet that has 9 rows.  Column A is numbered 1 -9 (each number only being used once).  

 

I would like to have the names from column B on the first sheet show up across multiple cells in a horizontal fashion on the second sheet (one name per cell) to correspond with the number from column A.

 

I am using 2010 Excel. Any help would be greatly appreciated.  Thank you.

By: Cliff

Leave a Reply

Your email address will not be published. Required fields are marked *