Lookup help #2

I am using vlookup match to pull data from a .CSV file and I need to
list in my new sheet any data that is held under a certain name, if
that name is repeted the first entery of that name my lookup picks up
continuously.

How would I be able to use a lookup that would pick up all the enteries
under that name going through a long list of data?

Thanks


-- 
Barky
------------------------------------------------------------------------
Barky's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14914
View this thread: http://www.excelforum.com/showthread.php?threadid=265436

0
10/1/2004 12:30:46 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
420 Views

Similar Articles

[PageSpeed] 18

Hi
provide some example data (plain text - no attachments please)

--
Regards
Frank Kabel
Frankfurt, Germany

"Barky" <Barky.1dg6wm@excelforum-nospam.com> schrieb im Newsbeitrag
news:Barky.1dg6wm@excelforum-nospam.com...
>
> I am using vlookup match to pull data from a .CSV file and I need to
> list in my new sheet any data that is held under a certain name, if
> that name is repeted the first entery of that name my lookup picks up
> continuously.
>
> How would I be able to use a lookup that would pick up all the
enteries
> under that name going through a long list of data?
>
> Thanks
>
>
> --
> Barky
> ---------------------------------------------------------------------
---
> Barky's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14914
> View this thread:
http://www.excelforum.com/showthread.php?threadid=265436
>

0
frank.kabel (11126)
10/1/2004 3:28:09 PM
Reply:

Similar Artilces:

Money2002 #2
I have been using Money2002 quite uneventfully for several years. When I tried to sign-in today it wold not accept my password. It keeps prompting for my sign-in name and password neither of which has been changed since the beginning. I have tried clicking the "Forgot you password" option but that does nothing. The sign-in screen is the "Microsoft Passport Sign-in" screen. I did try recently to enroll to try-out the new Microsoft Beta Office but found the process with Password too confusing and gave up in the process. Could I have in some way unintentionally fouled ...

help!! #2
Hi. can anyone help me solve this formula on excel.. =IF(PlanA=0,PlanB,PlanD) Thanks -- reddie12345 ------------------------------------------------------------------------ reddie12345's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28500 View this thread: http://www.excelforum.com/showthread.php?threadid=480997 see solution in your other post: http://www.excelforum.com/showthread.php?t=480996 PLEASE don't multi-post, as this wastes the time of the volunteers who spend time answering in one location when the problem has been already solved in another...

Error sending email #2
Hi I am trying to send email from within access. When I try to create outlook from within access using Set objOutlook = CreateObject("Outlook.Application"), I get the 'Automation Error, The specified module could not be found.". I can see the outlook 11 reference in the reference so not sure why it can't find outlook. This app is working fine on other machines so the problem has to be with this machine. What is the problem and how can I fix it? Thanks Regards ...

Excel>Data>Import External Data>New Web query #2
Hi I am trying to use Excel 2003 to import data from http://bigcharts.marketwatch.com/quotes/default.asp?refresh=on&rand=8519 I use new web query on the above url. I select the data in the block under 'My Favourite Quotes' The wizard behaves as expected but only returns 1 line not the 3 that have been selected. Can someone please give me some pointers on how I can get the 3 lines. Thanks Bruce Try yahoo instead or go here and get my FREE excel file for quotes or history. Look for donaldb36 as author. xltraders@yahoogroups.com -- Don Guillett SalesAid Software donaldb@...

Signatures and formats, Help Please
Ok, Here is the situation: - Outlook 2000 Workgroup Only format to send mail: HTML - Exchange Server 5.5, provides messages for pop3 and imap: html. - Outlook Express 6 (POP3 access) sends and receives as html. all email clients have a png file as signature, inserted with html code. (<img src= /> Situations: a) Outlook 2000 WO, sends email to another Outlook 2000 WO, signature Ok. b) Outlook 2000 WO, sends email to Outlook Express 6 (or any other client with pop3 access), signature NOT ok. (appears a red X telling me that it can't find the file) c) any other client (not our ...

Returns Issue pls help!
I have not been able to figure this out and i hope i am overlooking something small. My warehouse staff had done partial receipts of a po and on the last receipt then did it incorrectly. the po only has two line items but on the final packing slip the items had been listed inversley from the po. So this caused the warehouse staff to under recieve one item and over recieve the other but everytime i try to do a return i get an error The quantity returned can't exceed 0. This is the maximum available based on tthe item and receipt number. Please enter a smaller quantity to return....

Static CMap object #2
Hi all, Excuse but the other message is wrong I've declared in my .h file the following CMap type : typedef CMap<CString, CString&, MyClass*, MyClass*&> Map; ... ... class AnotherClass { ... public: static Map BuilderMap; ... ... static void Register(CString name, MyClass* instance); }; In one of my CPP file call the Register method as following: AnotherClass::Register(_T("TEST"), this); The code of Register method is : void AnotherClass::Register(CString name, MyClass* instance) { AnotherClass::BuilderMap.SetAt(name, instance); } When linking my project there t...

how can I exceed the nested if fuction limit #2
I am trying to create a validation for a column based off of the previous columns value, which reqires many nested if functions, (10 to be exact). However the limit of 7 nested if function prevents me from being able to do this. With all the amazing things that excel can do, there has to be some sort of work-around for this. Any ideas? Usually the best alternative is to use a Lookup function, however, without more details its hard to give a fuller explanation. _____________________ Naz London "mgdye" wrote: > I am trying to create a validation for a column based off o...

SOAP SDK tool V3 #2
Can any one let me know how to configure SOAP SDK tool, to capture data between, Java code and C# webservices. If any one has answer please let me know. rgds Nuts *** Sent via Developersdex http://www.developersdex.com *** ...

Dear God
I'm nearly going out of my mind trying to format a Mileage Log in Excel 2002. My needs are specific and don't seem to fit any of the ready-made templates out there. I need the day-numbers in a month (1-31) down the left-hand column. Excel (being written for nuclear physicists who don't appear to bother with such things) won't allow me just to enter numbers. Every number I type in those cells comes out as 0. I have tried formatting the cells to "Number" with no decimals, to no avail. (I am NOT going to write in every number in this Log as "1.0"...

How access Irish Pension Board Spreadsheet PRSA charges? #2
My Email address is lvmcn1@hotmail.com I am looking for details of the charges commissions and durations of PRSA's so as to get my ssia money out of my current account where it is gaining no interest!!!! Having no clue as to where to find the spreadsheet, website or anything else, not much to offer. Do you have a copy of the spreadsheet? If so, what problems are you having getting the information from it? Is it only available for viewing at a website? A web query might get you the information you need. Not much for us to go on here. "Lum" wrote: > My Email ...

80070490 kb967723 but kb967723 was successfully installed 2 months
So what gives? Why does auto update continue to try to install this update? It just started trying to (re)install this update again a couple of days ago. I am also getting this for kb972145, which was also successfully installed 2 months ago. -- lucky jack lucky_jack wrote: > So what gives? Why does auto update continue to try to install this update? > It just started trying to (re)install this update again a couple of days ago. > I am also getting this for kb972145, which was also successfully installed 2 > months ago. The error is occurring because there'...

Need help with Alphanumeric Auto number combination
Access 2000. I need a to assign an Audit number that is alphanumeric and partially auto number and partially assigned by the user. Example: Audit Number: 01086AB07 The first two digits of 01 is the first audit, which will advance one number automatically for each audit (Textbox). The second, third and fourth digits are the julian date which will be set to default(Textbox). The fifth and sixth digits are assigned indicating a company name(Combobox) for selection by user. The last two digits are the year which will be set to default(Textbox). I need this alpanumeric sequence to en...

Conditional Formatting Formula Help Part 2
Hi, I am working on a conditional formatting formula that will refer to a different worksheet that the one it is in, I hope this can be done, so here's how the formula needs to be: in cell X2 of worksheet "10 DAY AVERAGES" I need a formula that tests cell W2 in worksheet "PASTE DATA" to see if it's greater than the 20 day average of cells W2 through D2 in worksheet "PASTE DATA", and if so I will program a certain highlighting color via conditional formatting, I would appreciate very much some help with this formula THANKS! -- RalphSE ---------------...

Office 2008 doesn't install
Hi,<br> <br> when I tried to install it said it can't find software to install, just after choosing the install location. what's going on? I have office 2004 installed. problem solved - I had to change the system language to english before installing! ...

Problems with nt-backup #2
I know that only the transaction logs are backed up. But if i have one full-backup and and a differential backup i can restore my system if is crashes wright? Or is it better to make everyday a full backup? "Ed Crowley [MVP]" <curspice@mvpsnospam.org> wrote in message news:%23mPbzLHwFHA.212@TK2MSFTNGP12.phx.gbl... > Are you sure you really want to do a differential Exchange backup? You > understand that a differential Exchange backup only backs up the > transaction > logs, right? > -- > Ed Crowley > MVP - Exchange > "Protecting the world from ...

Help! Can't boot even to safe mode. Can't re-install OS. 0xc000
Hi all, I'm hoping some experts are on the discussion group here because I am getting close to a dead end. I am trying to help a friend restore his Windows XP installation. It's a real doozie. He has a very expensive CAD program on it and wants to avoid at all costs wiping the hard drive clean and losing the program -- for which he has no installation software... (I know, that was a dumb thing to lose the installation software, but it's been my experience that it's all too common among the non-geek population...) --This is a Dell laptop, but there is no re...

Charting Text #2
Below sample data I am trying to chart but I'm not sure if Excel can do this. It is basically a record of animals (tags) and where they have been spotted. I am trying to create a chart (maybe a scatter) with Location and Month on the X & Y axis and the tag data to appear to show a sighting. I have created a work around using a pivot table but the person looking at this chart is not an Excel user and I want to keep it simple. Any suggestions? Location Month Tag NW Jan J33 NW June J34 SW May J33 SW June J35 E Oct J36 E Nov J35 W May J33 W Apr J34 Hi, Insert new blank columns ...

Formula help...
I need help in devising a formula that will subtract 100 hours from a specific date and time. For example, if I entered a date and time (1/20/04 @ 1140) I would like the formula to subtract the 100 hours and give me that date and time (1/16/04 @ 0740). Is that possible? If you enter your date and time as a real date and real time: 01/20/2004 11:40:00 You can just subtract the 100 hours (100/24 represents 100 hour) =a1-(100/24) and format as mm/dd/yyyy hh:mm:ss (or your favorite date/time format) 1 = 1 day = 24 hours. So 100/24 is really 4.167 days (or 100 hours). BB wrote: > &...

Messenger #2
Does the standard version of Exchange Server 2003 have the "MSN Messenger"-like server on it? I remember Exchange Server 2000 having the server, but can't find it on 2003. Thanks, Neil Hi Neil The Instant Messager feature of Exchange 2000 has been replaced with a new product called Live Communication Server: http://www.microsoft.com/uk/office/livecomm/prodinfo/default.mspx -- Mark Fugatt Microsoft Limited This posting is provided "AS IS" with no warranties, and confers no rights. "Neil Shaw" <newsgroups@nshaw.co.uk> wrote in message news:%23%2...

partner programs... need help..
Hi. I used to work on restaurant POS software, and try to work on MS RMS. I was looking at the MS partner programs, but couldn't find information about MS RMS reseller(or partner) program. So.. which partner program do I have to get in? Thanks guys.. First become a Registered Partner - you just have to sign up, there's no fee. Then you'll need to take an exam at a testing center to become certified to sell RMS Store Operations. If you want to sell Headquarters, there is an additional exam. Your first stop should be http://partner.microsoft.com - once you become a register...

email sending problems #2
when sending emails to certain adresses, i recieve an error stating the email couldn't be sent because the adress was rejected by the server. it says "server error 550." it's really annoying because then i have to go into a webmail and send it out that way. i would say about 50% of my outgoing mail will not send because of this reason. any advice? thank you ...

1 forward mailbox for 2 outlook mailbox's
Can we use 1 forward mailbox with two outlook mailbox’s? Please provide your valuable inputs. Thanks in advance and help appreciated. BB ...

General Question #2
Is there a function that if I wright text in one box, there is an automatic addition of a number in another box? Peter. Yes, probably. We'd need some more information, though, to offer you help on which function to use and how. Andy. "Peter" <anonymous@discussions.microsoft.com> wrote in message news:760FE797-48B6-4AE1-AFC0-B73F92395E18@microsoft.com... > Is there a function that if I wright text in one box, there is an automatic addition of a number in another box? in cell a2 =if(a1="mytext",2,"") -- Don Guillett SalesAid Software donaldb@28...

Simple macro help #2
I have a workbook with two sheets in it. the workbook is used to keep track of machines in a particular location. on one sheet there is a weekly update and the second sheet is a year to date tracker. what i'm trying to do is on the weekly sheet i want to update the numbers for each location, weekly obviously. on the other sheet i want it to keep track of the yearly amount. for example on the weekly sheet i have 3 machines in memphis and 4 in los angeles. the yearly sheet will read 3 for memphis and 4 for los angeles. then at the end of week two i update the weekly sheet saying there...