Using an Index,match,search formula

[biroda]

Hi

I have a bunch of data (for e.g. from D3:K10) with headings in columns D2:K2 and rows C3:C10.

Long story short, the headings in columns D2:K2 include multiple texts that cannot be rearranged for other reasons. I need to be able to search through these headings to find a specific text (e.g. KFC) and implement the row number for my data series into my index match formula.

Does anyone have any ideas on how I can do so?

Thanks in advance.

 

[biroda]

Disregard this - I was able to solve it using index,match,search by itself.