Thread
:
formula probles - so lost
View Single Post
#
6
Posted to microsoft.public.excel.newusers
paul
external usenet poster
Posts: 247
formula probles - so lost
you need to filter or sort to find more than one row.Sorry i misundertood
your question
--
paul
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
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
Reply With Quote
paul
View Public Profile
Find all posts by paul