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.