Formula for putting descriptive text in certain cells conditionally

[Nate Westcott]

I have attached a spreadsheet with descriptive text entries in some of the columns, and I am wondering if there is a formula I can use to get certain text entries to appear in certain cells on a different sheet, based on a few conditions.

On the sheet, there are rows of alternating text and numbers. There is a name associated with every row, and there are three rows of data for each name.

I'm hoping to have a formula e.g. the values in column G on Sheet2 for any row which begins with name "Jimmy"... in cell B5, B8, and B11 on Sheet1. The name "Jimmy" appears in cell B2, so whatever name appears there is the name to which the text entries should correlate. In other words, if we change the index value to "Sam", the text entries for Sam should appear.

Is this possible with formulas, or should I be trying to do this with VBA?

Thank you, for any help anyone can offer!

[JBeaucaire]

On Sheet2, put this indexing formula in T1 and copy down:
=IF(Sheet1!$B$2 = $A1, ROW(), "")


On Sheet1:
B5: =INDEX(Sheet2!G:G, MATCH(SMALL(Sheet2!T:T, 1), Sheet2!T:T, 0))
B8: =INDEX(Sheet2!G:G, MATCH(SMALL(Sheet2!T:T, 2), Sheet2!T:T, 0))
B11: =INDEX(Sheet2!G:G, MATCH(SMALL(Sheet2!T:T, 3), Sheet2!T:T, 0))