Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2000 wont let me create chart | Charts and Charting in Excel | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) | |||
Writing many lines on a same Excel 2000 cell | Excel Discussion (Misc queries) | |||
Excel 2000 crashes Win98 when I save. All reloads failed. | Excel Discussion (Misc queries) | |||
pivotcell object to excel 2000 | Excel Discussion (Misc queries) |