Hi,

First of all, I'm not so familiar creating a big formula on MS Excel and even on MS Access.

I'm looking for a formula that when I enter value in MS Excel for example 12345, it gets the corresponding data from MS Access and it will display the result on the same MS Excel that I'm using. For example,

I entered in my Excel file, 49999 and it will display a result of National. And this data "National" stores on MS Access.

Can someone help me with this? I think this is not so hard to do for those who knows programming.

This is not simple and you have given us no information anyone could work with.

Quite apart from the fact we know nothing about your database structure, the coding to extract your data from the database requires an SQL query and we can't do that without detailed knowledge of the database. And, just to make it more difficult, that query would probably have to be run from a macro (i.e. using VBA) in the workbook and we don't know anything about its structure or where you want the data to go.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]