Search #7

Can anybody help me!?! I need to have a formula which can search a value from 
another worksheet. I need this for part of my macro, I have tried usind the 
find function in excel but the macro only records the value that was in the 
cell when it was recorded.

The find function would work great if there was any way of making the value 
searched for the value in a particular cell.

Any help would be MUCH appreciated.

Many Thanks 
0
Utf
11/6/2004 3:12:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
386 Views

Similar Articles

[PageSpeed] 46

You may want to post more details, but at first blush, you may be able to use 
=vlookup() 

It allows you to specify a value and return a value from a cell in the same row
as the matched key value.

For much better instructions, visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html

HELPME! wrote:
> 
> Can anybody help me!?! I need to have a formula which can search a value from
> another worksheet. I need this for part of my macro, I have tried usind the
> find function in excel but the macro only records the value that was in the
> cell when it was recorded.
> 
> The find function would work great if there was any way of making the value
> searched for the value in a particular cell.
> 
> Any help would be MUCH appreciated.
> 
> Many Thanks

-- 

Dave Peterson
ec35720@netscape.com
0
ec357208423 (183)
11/6/2004 4:41:16 PM
Reply:

Similar Artilces:

Search in Outlook
Why is it that search is so bad in Outlook? We had to pick up Lookout for searching outlook, and they have been bought by MS. Does this mean Outlook will have a good indexing and search function now?? This isn't an overnight thing. The technology will probably be used for all types of searching so most likely also for the future release of Outlook. -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -Backup and Restore -Create an Office XP CD slipstreamed with Service Pack 3 ----- "BAndrews" <bandrews@trendinfluence.com> wrote in message new...

need help #7
I want use microsoft outlook. But I couldn't able to use it. There is unsend E-mail. And blocked from sending any e-mail. How can delete it and would able to use it? Thanks in advance Abu Learn how to post a question: http://dts-l.org/goodpost.htm --=81 Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. =20 After furious head scratching, abu asked: | I want use microsoft outlook. But I couldn't able to use...

FRx V 7.5
Does anyone know if this is compatible with GP's 7.5. I know it was distributed with GP's V8 but can I run it without the GP's upgrade? Thanks ...

Multiple Descriptions Search
Customer wanted to have the capability to search multiple descriptions when issuing or purchasing an item. Examples: 1. In Item Maintenance window (Cards >> Inventory >> Item), click the Item Number lookup button and click the Advanced Search button then The Search Items window will appear. He would like to have the option to search multiple descriptions and expand the allowable characters on the value field. For example Item 'abc' has a description of '123, 456, and 789.' 2. In Item Purchasing Options Maintenance window (Cards >> Inventory >> I...

2500 Awesome New Fonts Collection July 2010.exe (7/7)
=ybegin part=7 line=128 size=1593897 name=2500 Awesome New Fonts Collection July 2010.exe =ypart begin=1497601 end=1593897 �C[=@a=}�/��`�5Ҵ�b��,�'���r�?������/��3NV���q���w�3x��`A���7,$D2=J_SOfu�4p�"��Z&N�褜#-n���̷�@��r�/��5�QҬу��� I͠)?{7@�%��[�ym�z��^�~�:���ڑYdkŝ��� Dx���@3��8�p+�"y��$E�ޓeْ2�b<=}STTY]�=@T9W�6����P�%��C��^o�x+1��c�5[O|N�I�KD xb��1Œ�bz$Ӭk�#⺶H���C:��h��,E�?�\?���~��0볈�j�+���T���ay�$���Y%��-��5���<=}�i+�?O�7�#�m�%V�d��9Bc>Qv_;=}�V��w� ��&�S�F6����3���/;^�n�x��=J���>�$��H���WK�\�-�v�+:dyw�=J��A���n���J-...

how to eport health level 7 data to excel
how to export HL7 data file to excel GM -- That's a question you need to put to your IT guys. Your computer system will need to create a report, saving it either in Excel format or something called a 'delimited ASCII' file, which Excel can open and then start using. Either way, you need to talk to your geeks. HTH "gm" wrote: > how to export HL7 data file to excel ...

Windows mail searches all folders
When I click on the Send and Receive button, Windows Mail searches through all my folders. How do I change to check only in my Inbox folder. I am sorry, but I think no one will understand your question. Send and Receive does not search folders. And Send and Receive does not check the Inbox folder; the Inbox folder does however show received messages. I can understand that many people that are unfamiliar with computers won't know what terminology to use to ask a question but unfortunately we need to be able to understand the problem in order to try to help. Is there someone ...

Searching for private meeting on primaries calendar
We have an admin who has delegate access to her primaries calendar. She also is set to view private meetings on the calendar. She is unable to use Windows Desktop Search to find any of these private meetings on his calendar even though she can browse to them and view them on the calendar. We are using Office 2007 on Exchange 2003. Any suggestions? Is this even possible? ...

Contact search fails to show results
The search fuction in Outlok works in mail and tasks and gives results, but fails to do so when searching for conacts (immediatedly shows 0 results). I think many people have had the same problem but mine is confined to the contact search (vista 32 and outlook 07). I have always used the Contacts Lookup window in the toolbar. Works a treat on surname and firstname. Unreliable on Company. You don't even need to have the Contacts folder open - ie you can be in your Inbox and type into the Contacts Lookup window. Regards Judy Gleeson MVP Outlook www.judygleeson.com...

cannot setup 3rd account with Ameritrade
Original problem was I could not set up my ROTH and IRA accounts with Ameritrade, only my trading account. I searched the FAQ sites found the answer and set them up. Now I can't re-setup my trading account. I tried all day then finally decided to permanently delete the trading account after I found, made a list, and deleted all the linked transactions from my other accounts. I gave the account a new name and set the financial services name to Ameritrade Stocks. Went through the online setup and after it connected it said "No online services available". The account is not listed i...

Dynamics CRM search for accounts beginning with multiple letters
Is there a way to retrieve all records from CRM into Excel that begin with multiple letters? For example, would like to retrieve a list of all customer accounts that begin with the letters F-G and H. (in a single query) Thanks for any ideas. Pierre On Feb 2, 11:33=A0am, Pierre <cow...@aol.com> wrote: > Is there a way to retrieve all records from CRM into Excel that begin > with multiple letters? > For example, would like to retrieve a list of all customer accounts > that begin with the letters F-G and H. =A0(in a single query) > > Thanks for any ideas. > Pierre ...

Office 2002 standard on windows 7
Office 2002 will not install on this windows 7. It gets halfway and then I get a message that it can't read the program. Any help. This is windows 7 home edition, Please post the full error message when asking for assistance. Thanks! -- Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. ALWAYS post your Outlook version. How to ask a question: http://support.microsoft.com/KB/555375 After furious head scratching, James The First asked: | Office 2002 will not install on this windows 7. It gets halfway and | then I get a messag...

Visual Studio 7 project subfolders #2
I know this may not be the exact group to ask this in, but in VS6.0 I used to be able to create subfolders within a project to keep my classes divided up conveniently. I just got VS7, however, and i can't seem to find any way to create subfolders. I can create subfolders for an entire SOLUTION, but not within a project. Am I missing or forgetting something here? Thanks! Duy Lam ...

Exchange 2003 SP2 on a Win2K3 with IE 7
Hi, on an Exchange server, since we have updated it to IE 7, public folders are not working. Neither on the ESM or, even in Outlook for mailboxes on that server. If we go to ESM on another server where IE 7 is not installed and look into the content of the same replicated public folder, we see it's content. Has anyone seen this ??? Thanks !!! -- -- --- *I'm guessing* - this may be related to the DHTML Editing control not being available on IE7 (though this is related to IE7 on Windows Vista, there have been isolated reports of this occurring on IE7 on Windows XP as well)....

Access Query
Good Day Situation: I have a query in which I am trying to create to address the following data in my table. The coding is created in two parts Changes completed (qryTask): SELECT [tblWorkload Information Tracker].ProductionAssigned, [tblWorkload Information Tracker].DatatrakNumber, [tblWorkload Information Tracker].DateReceived, [tblWorkload Information Tracker].WorkType, [tblWorkload Information Tracker].WorkCategory, [tblWorkload Information Tracker].EffectiveDate, [tblWorkload Information Tracker].QandALead, [tblWorkload Information Tracker].QAComplete, (IsNull([...

Exporting from Netscape 7.1 to Outlook
Hello dear newsgroup participants, I have following question: Is it possible to export from Netscape 7.1 to Outlook directly without any additional commercial software? What is meant with directly? I know that it is possible to some extent to export mailbox using some transitive relation between Outlook, Netscape, Eudora or between Outlook, INAP server and Netscape but I do not know whether these ways were succesful and I would prefer to do it without intermidiary steps. Is the process of exporting from Netscape 7.1 to Outlook described somewhere, so that one can follow the description and th...

Customization Guide #7
Can somebody please email me customization guide at manoj_rastogi@hotmail.com Thanks in advance Manoj hi Majoj, check your email "Manoj Rastogi" wrote: > Can somebody please email me customization guide at manoj_rastogi@hotmail.com > > Thanks in advance > > Manoj Can you send to me as well? Thanks. Scott @ sbinder@venus.com "Akber Alwani" wrote: > hi Majoj, check your email > > "Manoj Rastogi" wrote: > > > Can somebody please email me customization guide at manoj_rastogi@hotmail.com > > > > Thanks in adva...

compiled on visual studio 2003 on windows XP, want to install on windows 7, error
Hello, I have a VB.Net program, which I wrote on my windows XP pc (all recent updates installed), and I created a setup project for installing the program. Now I want to install that program on windows 7, but there I get a message: .Net framework 3.5 needed. Unfortunately, the latest version of the .Net framework is installed on the windows 7 pc. Anyone has experience with this problem? Does anyone knows a solution? Thanks in advance. Steven I think that for most people including me is to run the Windows Update first when they have installed Windows 7. Somehow thi...

Search sites not working
Hello Again: When I originally created my Sharepoint 2007 publishing site, I decided for whatever reason that I didn't need the default search site or the site map and deleted them (everyone is saying doooh!). So I am trying to configure a new search site but nothing is working correctly. I am assuming that I need to link the new site to the old database some how, but not having any luck. When I do a search, I get this message: System.InvalidOperationException: The search application "54fd814d-7774-4c0b-a4f9-6f473adedd4d" is not ready. at Microsoft.Office.Ser...

html #7
Hello, All message I do reply or forward I have to send in HTML format, but some of them I receive in plain text. Is it possible (in MS Outlook 2007) automaticly convert all incomig messages to HTML format? If not - is it possoble to force automatic coversion that all RE or FW message will be in HTML format? The keyword is: AUTOMATIC ;-) Thank's in advance. M. "M." <no@spam> wrote in message news:4a5cdc44$1@news.home.net.pl... > All message I do reply or forward I have to send in HTML format, but some of > them I receive in plain text. > Is it possible (i...

Outlook Rules #7
My outlook rules appear to be corrupted. The rules won't fire and I can't create and save new ones. I can create them and even run them, but when I try to exit the Rules Wizard I get the message "The operation failed. An object could not be found." The old rules will not delete, that is to say, I can delete them, but can't exit the Rules Wizard without the same error message above. Wat can I do? ...

Two Level Search
I have simplified the example ----- I would like to search the table shown below and determine the amount Pledge by each family. However since there are last names that are the same, a simple vlookup does not work. For example, I must define my search so I get Bill Johnson, not Frank Johnson. For the example, I would like the search result to appear in the column labeled "Search Result". Fund Raiser Invitations and Followup Roberts 22-May Y/N Invited Attended Pledged (amount) Search Result Smith Bill Marla N 1000 Smith Jon S...

Error message #4.4.7
Hi, I get a lot of the following delivery error messages from our Exchange2003 system: Message could not be delivered to following address ??? @???.??? <skh2003.skh.fi #4.4.7>. Yet the address is valid and can be reached from another mail domain. Can somebody please help? Matti Matti, http://support.microsoft.com/default.aspx?scid=kb;en-us;256321 this details the most common ndr codes, 4.4.7 is stated as being "Delivery Time Expired" Simon "Matti Makela" <anonymous@discussions.microsoft.com> wrote in message news:113301c3fb84$f9882590$a401280a@phx....

Page Numbers #7
i have a workbook with 40 worksheets, each worksheet is one page. I want to print all 40 with a page number. I kno wI can select them all, go print preview and then print with the page numbers. But this workbook goues to many people. I want to use a macro that will print the 40 pages numbered 1-40. Thanks, Tom This should occur automatically (and by default). If you are choosing to print your entire workbook, and if you select all sheets, go to File-->Page setup, and make sure page number is Auto. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "t...

Steps for Updating GP 7.5 to GP 9.0
Hi Need the procedure for updating tables of GP 7.5 running on SQL 2000 to GP 9.0. Assuming data exists in GP 7.5 How about: Read the upgrade manual and the latest updates to the process that are posted in Customersource. -- Lyle U Sandeep wrote: > Hi > Need the procedure for updating tables of GP 7.5 running on SQL 2000 > to GP 9.0. Assuming data exists in GP 7.5 ...