I have an excel spreadsheet and want to lookup some columns from an oracle database. ODBC is working fine.
To simplify the problem I have data in column A and to lookup data based on this column to appear in column B and C
So for example I may have....
XCEL COL A
ORACLE TABLE FRUIT
COLUMN 1 = FRUIT NAME
COLUMN2 = CITRUS_BOOLEAN
I want to do a lookup so that the spreadsheet ends up like this
COL A COL B
Column B is a lookup on Oracle based on the value of Column A
Is this possible?