stephenj789
Technical User
Hello folks. I would like to create a function in Excel as such:
Function(KeyItem, InfoType)
Where the KeyItem is a key item from from an Access database table, and the InfoType one of a number of fields from that table.
Basically, I would like to create a connection to the DB instead of opening up the DB and copying the data into Excel and doing vlookups (on the KeyItem). I have been unable to find out how to do this via internet search or looking at the Excel help files. If anybody could point me to a webpage or provide an example, it would be appreciated.
The following is an example of what I would like it to do:
=SALESPERSON(SalesPersonID, 1) would bring back the salesperson's region
=SALESPERSON(SalesPersonID, 2) would bring back the salesperson's first name
=SALESPERSON(SalesPersonID, 3) would bring back the salesperson's last name
etc.
Thank you.
Function(KeyItem, InfoType)
Where the KeyItem is a key item from from an Access database table, and the InfoType one of a number of fields from that table.
Basically, I would like to create a connection to the DB instead of opening up the DB and copying the data into Excel and doing vlookups (on the KeyItem). I have been unable to find out how to do this via internet search or looking at the Excel help files. If anybody could point me to a webpage or provide an example, it would be appreciated.
The following is an example of what I would like it to do:
=SALESPERSON(SalesPersonID, 1) would bring back the salesperson's region
=SALESPERSON(SalesPersonID, 2) would bring back the salesperson's first name
=SALESPERSON(SalesPersonID, 3) would bring back the salesperson's last name
etc.
Thank you.