Link Cells (Read for more info) -- HELP PLEASE

Ok, this is for more advanced Excel users. Here's the issue.

Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in 
S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number 
for a person, I want their name to automatically appear in COLUMN B from a 
list in S2.

This is how S2's list is set up... A1 has a person's ID #, and B1 has that 
same persons name. A2 has a different person's ID #, and B2 has that person's 
name, etc... So when I type the ID # in S1 in column A, it will lookup in S2 
and match that person's name with their ID.

I know this may be confusing, but I can't think of any way else to word it. 
Any help will be very appreciated. Looking forward to your comments. Thank 
you!!
0
Utf
4/4/2010 5:20:01 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
619 Views

Similar Articles

[PageSpeed] 23

VLOOKUP or INDEX/MATCH combo should do it;
http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
http://www.ozgrid.com/Excel/left-lookup.htm


-- 
Regards
Dave Hawley
www.ozgrid.com
"KeithD" <KeithD@discussions.microsoft.com> wrote in message 
news:221CE797-FB66-494B-8E38-E2F33FAE61D1@microsoft.com...
> Ok, this is for more advanced Excel users. Here's the issue.
>
> Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
> S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
> for a person, I want their name to automatically appear in COLUMN B from a
> list in S2.
>
> This is how S2's list is set up... A1 has a person's ID #, and B1 has that
> same persons name. A2 has a different person's ID #, and B2 has that 
> person's
> name, etc... So when I type the ID # in S1 in column A, it will lookup in 
> S2
> and match that person's name with their ID.
>
> I know this may be confusing, but I can't think of any way else to word 
> it.
> Any help will be very appreciated. Looking forward to your comments. Thank
> you!! 

0
ozgrid
4/4/2010 5:25:24 AM
Thank you so much... The vlookup worked for me.

"ozgrid.com" wrote:

> VLOOKUP or INDEX/MATCH combo should do it;
> http://www.ozgrid.com/Excel/excel-vlookup-formula.htm
> http://www.ozgrid.com/Excel/left-lookup.htm
> 
> 
> -- 
> Regards
> Dave Hawley
> www.ozgrid.com
> "KeithD" <KeithD@discussions.microsoft.com> wrote in message 
> news:221CE797-FB66-494B-8E38-E2F33FAE61D1@microsoft.com...
> > Ok, this is for more advanced Excel users. Here's the issue.
> >
> > Lets say I have two sheets in Excel, S1 and S2 respectively. Let's say in
> > S1, if I type a 4-digit number IN COLUMN A, which is actually an ID number
> > for a person, I want their name to automatically appear in COLUMN B from a
> > list in S2.
> >
> > This is how S2's list is set up... A1 has a person's ID #, and B1 has that
> > same persons name. A2 has a different person's ID #, and B2 has that 
> > person's
> > name, etc... So when I type the ID # in S1 in column A, it will lookup in 
> > S2
> > and match that person's name with their ID.
> >
> > I know this may be confusing, but I can't think of any way else to word 
> > it.
> > Any help will be very appreciated. Looking forward to your comments. Thank
> > you!! 
> 
0
Utf
4/4/2010 5:41:01 AM
Reply:

Similar Artilces:

SUMIFS help
Hi. Hope you’re able to help. I’m having difficulties the SUMIFS function. Either I’m using it incorrectly or perhaps it’s the wrong function for me! I’m trying to total the money amounts in column E as long as conditions in columns A (cell A6 in this example) and column H are True. However, I’m finding that the function is not totalling up the money amounts it should be totalling in column E. Instead, it’s just returning a single money amount in column E and ignoring the rest! This is the function as I’ve written it: =SUMIFS(BnkChqs!E3:E1000,BnkChqs!A3:A1000, A6,BnkChqs!...

newbie needs help
Hello, First to let you all know, I am a big novice at this kind of stuff, so please bear with me. What I am trying to do is make a trendchart with 9 different plots on it. How do I change the numbers on the side and bottom of the chart to read what I need them to? I take these tests 3 times a week and would like to chart all of them seperately and also together to chart progress for a whole month. One for each day, and then one for the month. Then I would like to do the same for the following months of the year. And I would like to have one chart to show the progress for the whole...

Read Online Statement -- All the Time in Money 2006?
I just upgraded to Money 2006 from the '04 edition. It appears that it always wants me to "Read Online Statement" for all of my investment accounts, even though there's been no actual transactions in the funds. I think all that's changed is the price of the fund or stock for the day. I don't think earlier versions worked this way, and it seems odd that it asks mne to Read the Online Statement after doing nothing than grabbing the day's latest prices. Is this what everyone is experiencing, and am I the only way to find this odd? Thanks, Paul Pinella Radar Media G...

Winmail.dat problem with SBS 2003..and yes i have read the other wiinmail posts
Ok, so I have read thru all the winmail.dat posts in this group and the outlook group, problem is most of them are geared towards ex 5.5. Well I have sbs 2003 and I have one user in my entire company that can not send a excell spreadsheet to one recp. without outlook 2003 i converting into a winmail.dat. I have tryed everyhting I can think of. I reinstalled outlook. I have sett all the options to send as plain text globally and for that contact that gets the winmail.dat files. I have been working on this for a while, but I do believe I checked the setting on exchange to allow the user to ch...

Help! Unable to mount public folder store event 9519
Hi, I am getting the following error when tring to mount the public folder store. Event Type: Error Event Source: MSExchangeIS Event Category: General Event ID: 9519 Date: 11/01/2006 Time: 00:10:26 User: N/A Computer: SERVER Description: Error 0x8004010f starting database "First Storage Group\f7967383-856a-4b7f-9023-37c269a0e908" on the Microsoft Exchange Information Store. Look up of DB Info failed. For more information, click http://www.microsoft.com/contentredirect.asp. I have tried numerous ms kb articles to no avail. I did find this on a news group :- -------------...

Formula help/suggestions?
I'm looking for help some help with a formula. How would I go about a formula for automatically adding 8 hours to a number each calendar month? I would like to open it and have it done for me if that's possible rather than having to remember to add it each month or forgetting if I did or not. For instance, i start out with the # 248 in a cell that I would like to automatically add 8 to each calendar month. "Gadgetman" <stoojz3@yahoo.com> wrote in message news:stoojz3-96EE83.15151022012011@usenet.ptd.net... > I'm looking for help some help with a formula....

Why Can't I Access Internet Links
I use Windows XP and IE 7 and suddenly one day I was unable to access internet links that were sent to me thru regular emails to my Microsoft Outlook. Any idea how to fix it? Thanks. What happens when you try? Any error messages? Hal -- Hal Hostetler, CPBE -- hhh@kvoa.com Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX http://www.kvoa.com -- "When News breaks, we fix it!" KVOA Television, Tucson, AZ. NBC Channel 4 Live at Hot Licks - www.badnewsbluesband.com "amirstal" <amirstal@gmail.com> wrote in message news:d7decb35-157c-4438-82bd-24a2536d347f@m36g2...

Linking Time-varying charts
Hi all, Here's my problem. I've got a set of Excel files with monthly data which is updated every month. So in January I only have Jan data. In February I have Jan and Feb data, and so on. The chart I have for this data always displays a full 18 months data from October 2003 to March 2005, and as more data is added, the line on the chart snakes its way from left to right. These files are submitted to me from various sources. As a central data collector, I now want to link these Excel files into a single Excel file which will display all the charts in one place for convenience. Ho...

Automatically inserting text into a cell
I have a formula in a cell that reads like this; =IF(A12="","",WORKDAY,(A12,5) In column M I am asking if a report is due Y/N. Can I add to the above formula to automatically insert "N/A" into N12 if there is a "N" in column M? One way: N12: =IF(M12="N","N/A",IF(A12="","",WORKDAY(A12, 5))) In article <39A51AAF-D44A-4356-B20A-71C8AA661338@microsoft.com>, Roy <Roy@discussions.microsoft.com> wrote: > I have a formula in a cell that reads like this; > =IF(A12="","",W...

How can you set up a form that the cursor only moves to cells tha.
I have set up a form. Now I want my cusor to move through the worksheet only in certain cells. I want to be able to go from one cell that needs to be filled out to the next cell that needs to be filled out automatically. Example , move from cell a3 to c19 automatically. How can I do that? Hi! You can accomplish that by setting sheet protection. Select all the cells that you want to be able to navigate to then goto Format>Cells>Protection tab. Uncheck Locked. Now, goto Tools>Protection>Protect sheet. A list of options will appear. Uncheck Select locked cells and check...

How can I autofill dates having a blank cell between each day?
Hi Dee, Enter a date in cell A1 (eg 5/13/08), enter the next day's date in cell A3 (eg 5/14/08). Select cells A1 trough to A4 (ie select two dates and two blank cells). See the little dot at the bottom right of the selection rectangle? Click on that (the cursor will change to a cross when you are over the right spot) and drag it down as far as you want. Ed Ferrero www.edferrero.com ...

I need help with a formula
Hi everyone I'm making a stock list sheet and I like to put on it the value - and + .. like when I take boxes out it will give me the total and when I add in it will change also. This is for a weekly count. I'm very new to excel so please H-E-L-P-. I need the instruction like u give it to a child. :) :) Thanks a lot -- pampam ------------------------------------------------------------------------ pampam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26224 View this thread: http://www.excelforum.com/showthread.php?threadid=395241 We need ...

formula help 02-10-10
Hi- Issue: 211 310 410 569 Would like to accomplish: 2211 2310 2410 2569 How do I add number 2 infront of the above ISSUE numbers as I have thousands of line to do. Soth If your number is in column A then in column B type =2 & A1 and copy it down. -- -John http://www.jmbundy.blogspot.com/ Please rate when your question is answered to help us and others know what is helpful. "Soth" wrote: > Hi- > > Issue: > 211 > 310 > 410 > 569 > > Would like to accomplish: > 2211 > 2310 > 2410 > 2...

Need Exchange limit help
I have a new SBS 2008 Server setup in a manufacturing environment. Two users within the company send and receive large CAD files. How do I allow this process? Right now one user is try to send a 185MB file and it is saying "the message being sent exceeds the message size established for this user." I have tried setting the limit in the console to 10GB and now I have unchecked the "enforce the mailbox quotas" box and he still can't send. If I go into the Exchange Management Console I still don't see how I can make this work. Is this something that...

How do I link multiple excel documents?
I need to link three Excel Documents into a master document that will reflect the data inputted into the others. as of right now they are all one document but that allows only one person at a time to enter the data, we need to have multiple people entering the data. Let's try for the easy solution first... Are people entering data on different worksheets, which are then captured on a 'master' sheet via equations? If so, open the file (make a backup copy first!), click on one of the input sheet tabs and select Move or Copy, then move the sheet into a New Workbook. Save th...

Can an email be read without internet connection?
Am downloading an email to CD, but the computer I need the CD for has no internet connection at present. Can I read & print the email without access to internet? This is an HP notebook & the computer I need to read & print the CD in is an IBM Aptiva 247. Hula Girl wrote: > Am downloading an email to CD, but the computer I need the CD for has > no internet connection at present. Can I read & print the email > without access to internet? This is an HP notebook & the computer I > need to read & print the CD in is an IBM Aptiva 247. Not sure what you mean b...

Linked Servers / OLE DB Jet4.0 request fails!
Hello I tried to execute an sql statement throught SQL OLEDB command It fails since I moved my configuration on 64 bits Windows 2008 Server System and migrate Sql Server 2005 to 2008. I want to execute an SQL Statement into an Excel file with Sql Linked Servers OleDbConnection sq = new OleDbConnection(); sq.ConnectionString = "Provider=SQLOLEDB;Data Source=xxx;user id=xxx;password=xxx;"; [...] sql = "insert into openquery(... FROM [Export$]) ... OleDbCommand c = new OleDbCommand(sql, sq); c.ExecuteNonQuery(); Returns : can't execute the query, prov...

Determine a cell's width and enter it in the cell
I have several workbooks with multiple sheets that I'd like to have the same various column widths on each sheet. I get it all set up and then one column will need to be wider. Now I have to go to a cell in each column, check column width, and enter it in each cell. I then have a sub that reads the value in a cell and sets the width to that value so that I can copy the row to each other sheet to resize them. Is there a way to automatically read a cell's width and enter that value in the cell? Thanks for any suggestions. As an alternative: you could "group" all the...

Convert Word Table -> Excel without merged cells?
Whenver I copy/paste tables from word to excel, I get merged cells in Excel whenever there are line breaks in the word table cells. How can I avoid this? TIA Steve Saved from a previous post: If your cells in your word table contain paragraph mark or linebreak characters, then excel will bring them over as separate cells. One way around it is to convert those paragraph marks & linebreaks to unique characters, then copy|paste and then convert them back to linefeeds. I like this technique (inside a copy of the word file): Select your table. Edit|replace|Special (show More if required)...

Deleting Parts of Cells
I have a list of information in a column. All the information has the format of having numbers and letters then a / and more data. I only want to look at the data to the left of the /. So, I would like the data to the right of the / deleted, including the /. For example, I need YYY9/5 to read YYY9. Any suggestions? You could bring it into Excel as a txt file open the txt file in excel Text Import Wizard will appear select >delimited check > other and type the "/" into the box finish you should have a separation where the / was. "GOL" wrote: >...

Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000 stores in 10 states - mostly in the South. We have many stores in the hurricane zones. During Rita and Katrina we decided we needed a better way to track how our stores are affected and what help we could provide. I've designed a database to do this. I have three main tables: tblHurricane Info: fldHurricaneYear fldHurricaneName tblUnitInfo: fldUnit - the unit number assigned to the store fldAddress fldCity fldState fldZip fldPhone fldDO fldMgr tblUnitForm fldAutoNumber fldUnit fldHurricaneName fldPr...

Transform a Cell from Formula to Number
Is there a way to turn a cell from a formula to the number the formula outputs? Copy it to the clipboard, then do Edit>PasteSpceial, click Values -- HTH Bob Phillips "Sloth" <Sloth@discussions.microsoft.com> wrote in message news:76DA206E-CFC3-4E63-9789-69735538E1A7@microsoft.com... > Is there a way to turn a cell from a formula to the number the formula outputs? Copy the cell. Edit/Paste Special/Values. In article <76DA206E-CFC3-4E63-9789-69735538E1A7@microsoft.com>, "Sloth" <Sloth@discussions.microsoft.com> wrote: > Is there a way to...

Stagnant cell for counting filtered data
I want to keep one cell that houses the count of the data depending on how it is filtered and that cell remain visible despite how it is filtered. I can't get the formula =COUNT(C9,C1:C100) to work or get it to stay visible if I change the filter. Place the formula in row 1 that contains your titles...........assuming you have these. =SUBTOTAL(2,C2:C100) the 2, means count If you don't have titles in row 1, place the formula after a blank row below your data. Note: you use COUNT in your original. COUNT only counts numerics. Maybe you want COUNTA which would be =SUBTOT...

how to get Outlook Express to continue after failing to read a newsgroup message
I use outlook express as a newsreader. Sometimes I want to get the entire server holdings of a particular newsgroup. Trouble is, OE seems to snag when it was able to read a message header but for some reason it can't retrieve the body. It snags with Outlook Express could not download the requested message. It is likely that the message was removed or expired from the server. Subject 'Simple security??', Account: 'news.nevrona.com', Server: 'news.nevrona.com', Protocol: NNTP, Port: 119, Secure(SSL): No, Error Number: 0x800C006F and the only op...

Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you enjoy the respect and additional income that could come from being able to help everyone in your office on Microsoft Outlook? Get your Outlook Specialist certification and realize the benefits it can have. "Are You Certifiable (In Outlook, At Least)" is available at http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go through each subject on the test and help you to prepare for this certification. If you do not plan to get certified but need a little extra help on using Outlook it is an excell...