Create an excel program with field forms and import details of matched inputted data in fi

**excelally** · 07-20-2013, 09:50 PM

hi!
im pretty much new here. Hope someone could help me. I wanted to have an excel program where there will be a field where when the employee id is inputted in column 1, details such as name, rank and position will be imported to column 2,3,4 and so on. I want it to be interactive.

need your help asap.

**MarvinP** · 07-20-2013, 10:37 PM

Hi excelally and welcome to the forum,

It sound like you need to learn how to use a VLookup function.
See example #3 on http://office.microsoft.com/en-us/ex...005209335.aspx
for an example.

Create an excel program with field forms and import details of matched inputted data in fi

LinkBack

Thread Tools

Rate This Thread

Display

Create an excel program with field forms and import details of matched inputted data in fi

Re: Create an excel program with field forms and import details of matched inputted data i

Thread Information

Users Browsing this Thread

Similar Threads

Adobe forms - possible to import data into excel? Make form from excel?

[SOLVED] Match staff name and date then import data from matched row (Example attached)

[SOLVED] Cross Match Date & Name then import data for matched row.

How to import data from a program into excel at a certain time interval?

Creating forms in Excel to Import access data ! Please reply

Bookmarks

Bookmarks

Posting Permissions