Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get excel to autofill the next column?
Hi there...I wonder how can I get excel to autofill the next column if....my sheet is like below... employee ID employee name employee dept. 00001 john doe training 00002 funny gal engineering etc etc can my worksheet get the data from elsewhere and i just need to type in the employee ID number and the rest will be filled in from the linking excel sheets or workbook? Is this possibble...thanks.. Jayman ;) -- jayman ------------------------------------------------------------------------ jayman's Profile: http://www.excelforum.com/member.php...o&userid=34871 View this thread: http://www.excelforum.com/showthread...hreadid=546194 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get excel to autofill the next column?
See the VLOOKUP function.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "jayman" wrote in message ... Hi there...I wonder how can I get excel to autofill the next column if....my sheet is like below... employee ID employee name employee dept. 00001 john doe training 00002 funny gal engineering etc etc can my worksheet get the data from elsewhere and i just need to type in the employee ID number and the rest will be filled in from the linking excel sheets or workbook? Is this possibble...thanks.. Jayman ;) -- jayman ------------------------------------------------------------------------ jayman's Profile: http://www.excelforum.com/member.php...o&userid=34871 View this thread: http://www.excelforum.com/showthread...hreadid=546194 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get excel to autofill the next column?
Jayman Try this: Build your lookup table just the way you posted your example. Assuming that table is located on a sheet named LISTS in A1:C100, with column titles in Row_1 (Employee_ID, Employee_Name, etc) Then....on another sheet....where A1: Emp_Id A2: (an Employee_ID) B1: Name B2: =VLOOKUP(A1,'LISTS'!$A:$C,2,0) C1: Dept C2: =VLOOKUP(A1,'LISTS'!$A:$C,3,0) (Note: instead of typing the table location, you can just use the mouse to switch sheets and select it. Excel will build the reference for you) Copy the formulas in A2:C2 down as far as you need. Does that help? --------- Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=546194 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
question for excel how to have linked sum in column? | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) |