Excel 2000 - How to create an auto search
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"echo7" schrieb im Newsbeitrag
...
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