Use MS ACCESS to lookup values

tvining

New Member
Joined
Jan 17, 2008
Messages
18
I have an existing spreadsheet that is used by another department.

I track data from their spreadsheet in my MSAccess database. What I would like is to make it so that the "F_Name" column in their spreadsheet is fed by a field in my Access database.

In other words, when you start to type "SMITH J" then the dropdown list will limit itself to "SMITH JOHNATHAN" and "SMITH JOHN C".

HOWEVER, occasionally (rarely) they will have a name that I don't have on my list.

The "F_Name" field is a full name, and is common to both documents, column A on the spreadsheet, and table TBL_MASTER_NAMES in the database.

Thanks,
Tony
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,752
Members
406,496
Latest member
Arlind Elezi

This Week's Hot Topics

Top