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

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bollard" wrote:
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