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