Re: Excel 2000 - How to create an auto search

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 17:32:10 +0100

Hi
have a look at VLOOKUP for this. See:
http://www.contextures.com/xlFunctions02.html 

-- 
Regards
Frank Kabel
Frankfurt, Germany
"echo7" <echo7@discussions.microsoft.com> schrieb im Newsbeitrag 
news:709085ED-2C2A-44A0-9492-42E4CB24DF00@microsoft.com...
> Hi,
> I wanted to create an automatic seacrh in MS Excel or MS Access. For 
> example
> in Column A1, I have "APPLE" and then column "A2" should search for the 
> unit
> price of APPLE in a database. And then on on cell B1=Orange, B2 should 
> search
> for the unit price of orange in a database.
>
> How do I do that
> thanks

Relevant Pages

  • Saving a calculation to a database
    ... I am facing a problem that is I have a form that includes text fields from a ... specified table in my database... ... My form is having text fields that displaying the record of the table. ... fields (unit price * quantity) and the result must be saved in a field of the ...
    (microsoft.public.access.formscoding)
  • Re: Export to Excel file
    ... "Alan" schrieb im Newsbeitrag ... > I will extract data from database and want to export fields of records ... > Excel format file. ...
    (borland.public.delphi.thirdpartytools.general)
  • (re)format output (data type) from SQLServer to DataGrid
    ... I have a couple of fields in SQL Server which are defined as "Money". ... "Quantity" and the other is "Unit Price". ... Changing the datatype to Integer in the database isn't an option here so I'm ... In a datagrid, the data in the fields is written to the aspx page as ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Get Caption from all Components in a Form
    ... "news.kabsi.at" schrieb im Newsbeitrag ... > value found in a database. ... compoent class is tlabel ...
    (alt.comp.lang.borland-delphi)
  • Re: WHY
    ... I know at least the Eurex and Xetra trading systems and they're NOT database ... schrieb im Newsbeitrag ... > Frank Kabel" wrote in message ...
    (microsoft.public.excel)