Finding entries across columns

[bollard]

Hello

I have a spreadsheet which has names in Column B.

In the next 6 or 7 columns, from Column C onwards, there are psoradic
entries. There may be an entry in Column C or D or E etc. There may also be
more than one entry.

I just want some way of returning only the first entry that occurs to the
right of the Name in Column B.

Can anyone help, plase?

Thank you.

Keith

 

[Don Guillett]

If looking for the next text. copy down
=INDEX(C1:H1,1,MATCH("zzzz",C1:H1))
or a number larger than possible
=INDEX(C1:H1,1,MATCH(999999,C1:H1))

 

[Max]

One way, assuming names in B2 down
Put in A2, array-enter the formula by pressing CTRL+SHIFT+ENTER:
=IF(COUNTA(C2:IV2)=0,"",INDEX(C2:IV2,MATCH(TRUE,C2:IV2<>"",0)))
Copy A2 down as far as required