Counting columns until certain data is found

Hello,

I need to count the # of columns from lets say a1 until a specific value is foun in the same row.

How can I do this?

Thanks for the help.