i posted this in general forum but i think its better suited here -
got a worksheet such as this:

SequenceId Musician Initial YOB YOD Instrument
1 Micheal A. 1975 1999 Chello
2 Tom I. 1960 1989 Piano
3 Hans J. 1982 2000 Piano
4 Hans J. 1982 2000 Keyboard
5 Hans J. 1982 2000 Orchestra

I want to be able to retrieve every information sequenceid,initia
yob,yod just by matching the name - i went through various match if
vlookup etc formulas but nothings working - at best i got the las
matches but not all of the possibilities - for example i only get 5 j
hans 1982 2000 orchestra but not all of hans is 3 possibilitie

--
hsb10
-----------------------------------------------------------------------
hsb101's Profile: http://www.excelforum.com/member.php...fo&userid=3704
View this thread: http://www.excelforum.com/showthread.php?threadid=56793

Depending on what you're trying to do.........you might check out Data >
Filter > Autofilter > then select the name from the drop-down arrow atop that
column......

Vaya con Dios,
Chuck, CABGx3



"hsb101" wrote:

>
> i posted this in general forum but i think its better suited here - i
> got a worksheet such as this:
>
> SequenceId Musician Initial YOB YOD Instrument
> 1 Micheal A. 1975 1999 Chello
> 2 Tom I. 1960 1989 Piano
> 3 Hans J. 1982 2000 Piano
> 4 Hans J. 1982 2000 Keyboard
> 5 Hans J. 1982 2000 Orchestra
>
> I want to be able to retrieve every information sequenceid,initial
> yob,yod just by matching the name - i went through various match if,
> vlookup etc formulas but nothings working - at best i got the last
> matches but not all of the possibilities - for example i only get 5 j.
> hans 1982 2000 orchestra but not all of hans is 3 possibilities
>
>
> --
> hsb101
> ------------------------------------------------------------------------
> hsb101's Profile: http://www.excelforum.com/member.php...o&userid=37049
> View this thread: http://www.excelforum.com/showthread...hreadid=567933
>
>

i need a formula - i just want to search a name and recieve some of the
information from the row that matches the name, i need multiple info
back in some cases 0 thats the problem i can only get one row so far

im guessing using something with the if function but im pretty lost


--
hsb101
------------------------------------------------------------------------
hsb101's Profile: http://www.excelforum.com/member.php...o&userid=37049
View this thread: http://www.excelforum.com/showthread...hreadid=567933

Hi I'm new but have quite a good knowledge of excel...


Have you thought about pivot tables?? I know you want a formul
but....

If you have the data split in to columns ie

SequenceId, Musician, Initial, YOB, YOD & Instrument


Then have the name in the page section and the admittedly it would be
count in the data area but you could have the rest of the data shown i
the column area.

Unfortunately I'm at work ATM and can't host pics but if you need to
can illustrate it better when I get home......


Sorry if I didn't explain too well but sometimes it easier to point a
stuff and have a play.


HTH (a little

--
mr_be
-----------------------------------------------------------------------
mr_ben's Profile: http://www.excelforum.com/member.php...fo&userid=3710
View this thread: http://www.excelforum.com/showthread.php?threadid=56793

use vlookup across as many columns as you need to display all the columns.
ie =vlookup(name,table,col2,false).In the next column
=vlookup(name,table,col3,false).In the next column
=vlookup(name,table,col4,false).
and so on
--
paul
(E-Mail Removed)
remove nospam for email addy!



"mr_ben" wrote:

>
> Hi I'm new but have quite a good knowledge of excel...
>
>
> Have you thought about pivot tables?? I know you want a formula
> but....
>
> If you have the data split in to columns ie
>
> SequenceId, Musician, Initial, YOB, YOD & Instrument
>
>
> Then have the name in the page section and the admittedly it would be a
> count in the data area but you could have the rest of the data shown in
> the column area.
>
> Unfortunately I'm at work ATM and can't host pics but if you need to I
> can illustrate it better when I get home......
>
>
> Sorry if I didn't explain too well but sometimes it easier to point at
> stuff and have a play.
>
>
> HTH (a little)
>
>
> --
> mr_ben
> ------------------------------------------------------------------------
> mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
> View this thread: http://www.excelforum.com/showthread...hreadid=567933
>
>

you need to filter or sort to find more than one row.Sorry i misundertood
your question
--
paul
(E-Mail Removed)
remove nospam for email addy!



"paul" wrote:

> use vlookup across as many columns as you need to display all the columns.
> ie =vlookup(name,table,col2,false).In the next column
> =vlookup(name,table,col3,false).In the next column
> =vlookup(name,table,col4,false).
> and so on
> --
> paul
> (E-Mail Removed)
> remove nospam for email addy!
>
>
>
> "mr_ben" wrote:
>
> >
> > Hi I'm new but have quite a good knowledge of excel...
> >
> >
> > Have you thought about pivot tables?? I know you want a formula
> > but....
> >
> > If you have the data split in to columns ie
> >
> > SequenceId, Musician, Initial, YOB, YOD & Instrument
> >
> >
> > Then have the name in the page section and the admittedly it would be a
> > count in the data area but you could have the rest of the data shown in
> > the column area.
> >
> > Unfortunately I'm at work ATM and can't host pics but if you need to I
> > can illustrate it better when I get home......
> >
> >
> > Sorry if I didn't explain too well but sometimes it easier to point at
> > stuff and have a play.
> >
> >
> > HTH (a little)
> >
> >
> > --
> > mr_ben
> > ------------------------------------------------------------------------
> > mr_ben's Profile: http://www.excelforum.com/member.php...o&userid=37106
> > View this thread: http://www.excelforum.com/showthread...hreadid=567933
> >
> >