Return Column Number when specific text is found

Hi All,

I am looking for a formula to return the column number of the array when a specific text is found, in this case the text is "Yes"

The Array will only ever be 5 cells beside each other in a row

for example, M4:Q4, will be as follows - No No No Yes No

I want a formula to look at these 5 cells and return the number 4 as that is where the "Yes" value is

Any help greatly appreciated. been trying some lookup formulas but cant figure it out

Simon

Perfect, Thanks very much, reputation added

Simon

Give this a try:

Please Login or Register  to view this content.