Ok, my spreadsheet skills may be showing a little out of date here, but I am
hoping an Excel-God can show me the light.

I have an array consisting of column A, column B, with 15 separate rows.
The array is periodically filled with various text strings, but the data in
column B always contains four occurences of the letter "X" in different boxes.

I think I need four formulas that will be similar - I want to find the first
occurence of "X" in column B and return its matching text label in Column A
as a result. In the next box, I want to find the second occurence of "X" and
return its label from Column A, and so on for the 3rd and 4th occurence.

In my youth, this was a simple matter of nesting IF statements, but with a 7
layer limitation and 15 rows to process, this isn't feasible. I'm probably
missing some learning on some better way to handle and test an array - so
clue me in if I'm missing a few brain cells on this one (cells - get it?)

Thanks!