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