How did I populate other cells based on infor from one cell?
in [General]
|
Prev: using Sumproduct with named ranges
Next: need a formula to find "*" in s string and multiply by preceding and following values
From: fkcadl on 21 Apr 2010 07:49 Hi, Ive got a spreadsheet with staff information such as network username, first name, surname, department, job title, ethnicity, age etc... How do I (if possible), automatically populate the first name, surname, department, job title, ethnicity, age etc... by just typing in the network username? Any help is much appreciated! fkcadl
From: Jacob Skaria on 21 Apr 2010 08:01 Check out help on VLOOKUP(). With your data in Sheet1 Col A to Col J; in Sheet2 enter the network username in cell A1. In cell B1 enter the below formula and copy/drag towards the right.. =IF($A1<>"",VLOOKUP($A1,Sheet1!$A:$J,COLUMN(B1),0),"") -- Jacob (MVP - Excel) "fkcadl" wrote: > Hi, > > Ive got a spreadsheet with staff information such as network username, first > name, surname, department, job title, ethnicity, age etc... > > How do I (if possible), automatically populate the first name, surname, > department, job title, ethnicity, age etc... by just typing in the network > username? > > Any help is much appreciated! > > fkcadl >
From: Dave Peterson on 21 Apr 2010 08:09
It sounds like a good time to learn about =vlookup() or =index(match()) (depending on how that table is laid out). Debra Dalgleish has lots of notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) and http://contextures.com/xlFunctions02.html#Trouble fkcadl wrote: > > Hi, > > Ive got a spreadsheet with staff information such as network username, first > name, surname, department, job title, ethnicity, age etc... > > How do I (if possible), automatically populate the first name, surname, > department, job title, ethnicity, age etc... by just typing in the network > username? > > Any help is much appreciated! > > fkcadl -- Dave Peterson |