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))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bollard" wrote in message
...
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