displaying a name in a cell reference

I have two worksheets in an Excel workbook.

Sheet1 has a prize designation column with different prizes i.e. WM20, WM10, 
etc

Sheet2 has the prize designation (WM20) matched with a name i.e. Walmart 
giftcard

I need to display the name from sheet2 in a column on sheet1?

Thanks
0
Utf
12/10/2009 3:01:01 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
619 Views

Similar Articles

[PageSpeed] 44

You could use a vlookup function to do that for you.

Something like this:
=VLOOKUP(B6,Sheet2!$A$1:$B$29,2,FALSE)

Assuming B6 contains “WM20”
Assuming the range on sheet2 A1:B29 contains WM20 in column A and the 
description “Walmart 20 buck Gift certificate etc” in it.

Hope that helps.

Frank


"JimboDB" wrote:

> I have two worksheets in an Excel workbook.
> 
> Sheet1 has a prize designation column with different prizes i.e. WM20, WM10, 
> etc
> 
> Sheet2 has the prize designation (WM20) matched with a name i.e. Walmart 
> giftcard
> 
> I need to display the name from sheet2 in a column on sheet1?
> 
> Thanks
0
Utf
12/10/2009 3:07:01 PM

Ah, VLOOKUP that worked.

Thanks very much
0
Utf
12/10/2009 3:44:02 PM
Reply:

Similar Artilces:

How can I hide letter in a cell?
I am trying to hide a letter in a cell, and when the cell is filled in with black, then have the letter appear. I am doing this on a reservation form. So make the text white? That way, if the cell is filled black, it'll show. ******************* ~Anne Troy www.OfficeArticles.com "Linds" <Linds@discussions.microsoft.com> wrote in message news:3F92F52E-1789-4872-B7D3-020AAB481F64@microsoft.com... > I am trying to hide a letter in a cell, and when the cell is filled in with > black, then have the letter appear. I am doing this on a reservation form. > Chang...

Saving Excel Docs as a 'Variable' Name
Is there a way to save an excel document, by a macro, that names it by a cell within the document? Also, is there a way, again using a macro, to open up specific files based on cells within the document? nm, got it. "ager_merityme" wrote: > Is there a way to save an excel document, by a macro, that names it by a cell > within the document? > > Also, is there a way, again using a macro, to open up specific files based > on cells within the document? nm, got it. "ager_merityme" wrote: > Is there a way to save an excel document, by a macro, th...

summing cells based on "like" value and cell color
Is there a way to look at a column and if the cell begins with 01,02,03....98 and the cell color is either yellow or pink to sum those just those cells? So what I'd like to do is sum all the cells starting with 01 that the cell background is yellow, then sum all the cells starting with 01 that the cell background is pink? Any help would be greatly appreciated. You will need VBA to count by colour. See http://www.cpearson.com/excel/colors.htm best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email <banderson@nwws.biz> wrote in message news:1157548360...

Inserting a cell in the header.
We are trying to get a cell in the header of a sheet. Can this be done? Example would be in our sheet in D9 is TFF. We want whatever is in D9 to go in the header. I'm not sure this makes sense. Thanks Wendy You could do this with a macro linked to the worksheet_change event. Insert the following code into the macro sheet for the sheet with the cell if interest. Private Sub Worksheet_Change(ByVal Target As Range) For Each Cell In Target If Cell.Address = "$D$9" Then ActiveSheet.PageSetup.CenterHeader = Cell.Value End If Next Cell End Sub -- mrice Research Scientist with ...

Mutiple Cells highlighted
When ever I try to select one cell on a Excel worksheet multiple cells are highlighted. It's like the right mouse button is been depressed, but it's not and the mouse is working fine and I even tried a new one. Thanks. Shawn, Look to see if "EXT" appears in the status area in the lower left corner of the Excel window. It is next to the Caps Lock and Number Key lock indicators. If "EXT" is displayed, that means you have the "Extend Selection" option turned on. This causes Excel to select a rectangular bounded by the previous cursor position and wh...

Line break in cell, char(10) square settings?
HI all! I have a problem regarding the char(10) square that appears when you press "alt enter" to get a line break in a cell. (When using Wrap text) When I use a cell reference to a cell with a line break the Char(10) square appears in some of my excel xp or excel 2003 installations but not all of them. I have tried to find some settings for this but I have not. I need the squere to get the line break back when I send the information to a database and back Do you have any suggestions? Thanks, Fredrik Format|Cells|Alignment|Wrap text The square is what char(10...

How to create a formula that results in a blank cell if required
I have a spreadsheet that is to be populated during the course of the year. I have a column which totals the number of days worked on a particular task and have copied the formula down the sheet for the number of entries required. Obviously, as the sheet is currently unpopulated, I do not want a whole load of zeroes listed in this column when the other cells in the sheet (which are used in the calculation) are currently empty. ie) what I have is (as a simple example) A B C ------------------------------- Hours Total Hrs Total Days 37 37 5 ...

Color shading on cells with same numeric content on three digit ce
Has made a numerical database containing three numbers in each cell and includes zeros, double and triple digit content. Note that leading zeros unseen and now having thousands of cells on my database. How can I command, (ex: 123, 132, 231, 213, 312, 321) be look up and color shade? Assumptions: A1 contains the 3 digit 'code' to enter. Note: If this is entered as text, then you don't need the A2 line, and just change all the A2 references from A3:A8 to A1. The first solution is if the numbers you are comparing your 3 digits to are actual numbers and not text. A2: =TEXT($A$1,...

coping with empty excel cells in the xml document
Hi I have an xml document that has been created from an excel spreadsheet. In the s/s there are some empty cells however these are not captured in the xml file. All that is added is for the cell after where the empty cell should be, it has an extra attribute: "ss:Index="6", where it is the 6th cell in the row, and cell 5 had no entry. I'm wanting to pick out a particular cell from a particular column however just iterating through the cells is going to give me invalid values where there should have been empty cells. Does anyone know how to handle this? I've tried ch...

Cell address
I want to do something like Offset(vlookup(a1,range,1,false),1,1). However I want the lookup function to return the cell address instead of the value. Any suggestions? TIA Tasha =CELL("address",INDEX(range,match(a1,range,0))) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom "Tasha" <anonymous@discussions.microsoft.com> wrote in message news:15AB6D29-EE4B-4B8A-A073-1489DA974125@microsoft.com... > I want to do something like Offset(vlookup(a1,range,1,false),1,1). However I want the lookup function to return the cell a...

excel
I have a total of 20 worksheets. The worksheet names are "q1", "q2" "q3" ... , "q19, "q20" (all without the quotes). In each sheet, I wan cell A1 to contain the name of the worksheet. When I change the name of any worksheet, the content of cell A1 (in th particular sheet) should also automatically change to the new name o the worksheet -- Message posted from http://www.ExcelForum.com If you place the following code into vba it should work. What it does i after you have changed the sheet names goto tool and there will be command there called re...

What does the 8.43 and 12.75 represent in height and width of cell
In working with excel I notice that the default width (8.43) and default height (12.75) seem to be visually different. What do the numbers represent? Height is measured in points (72 points to the inch) Width is measured in points (12 points to the inch) -- Gary''s Student "ljfrantz40" wrote: > In working with excel I notice that the default width (8.43) and default > height (12.75) seem to be visually different. What do the numbers represent? Row heights are measured in points or pixels. There are 72 points to an inch and "maybe" 96 pixels to the ...

Display items with they appear in different sections of a table
I have an Access VBA Form that uses information from various tables. The form I have used uses a subform. I am trying to set up a query so that it displays what work an employee has done. The user would select an employee from a list. That selected Employee would be listed in the main form. Example: EMPLOYE: joe smith Job 1 Job2 Job3 Joe Smith was assigned as employee1 on one job, employee2 on another job, and employee3 on the other. The list should display all occurances. The Query returns a value from the table form the employee 1 field. However, a job can have up to 3 emplo...

Get column name and data type from closed workbook
Good day Group, Found the code below from this group that helps me to retrieve the Sheet names from a closed Workbook. Is it possible to get the name of the columns (fields) from a Worksheet in a closed Workbook in the same way? Is it posssible to get the format (data types) of each column? As new to this I�am grateful for some hints. Brgds CG Rosen ---------------------------------------------------------------------------------- 'Sub GetSheetNames() Dim cnn As ADODB.Connection Dim cat As ADOX.Catalog Dim tbl As ADOX.Table Dim lRow As Lon...

Insert cell contents into header/footer
I would like to know how to insert the contents of a particular cell (in each worksheet) into the header/footer for the corresponding worksheet. Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftFooter = Range("A1").Value End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH Bob Phillips "joeeng" <joeeng@discussions.micr...

Employee Name change affects AD, Business Portal and GP
Anyone have a good process to follow when an employee changes their last name? The IT department has changed her name in AD and now portal is broken, I suspect I can simply delete and recreate the account in Portal and all the underlying transactions (timesheets and expense reports) will stay linked. For PDK and GP we've included part of the last name in the ID so we'll need to go with the Professional Services tool to fix that. Is there a recommended order to do all this or am I missing anything? ...

Using a Table as a Referance
Hi, I was wondering if there was any union code that i could use to use a table as a reference. what i mean is, if i had a main table that was related to this reference table by the primary key, and the reference table had fields choresponding to things in the in main table. this way, any one record in the main table would have a value in the reference table determined by two of the fields in the main table. i just realized how amazingly confusing i made that, so i will try to diagram it. MAIN TABLE: Joe - A - 1 Sally - B - 2 Kari - A - 2 Reference Table -- - 1 - 2 A - x - y B - z -...

Copy same values to several cells
I am using Excel 2003 to do some temperature modelling. I have a long list of daily average temperature. I want to create a new list where the each day is divided into periods of 6 hours and each cell is linked to the belonging daily average temperature. In my new list I want to connect the first five cells to the first cell in old list, then connect the next five cells to the second cell in the old list and so on. Since I am working with 10000 of data I need to find a method that can be copied down the coulomm. Say the old list is on Sheet1, Column A. Enter this anywhere in Sheet2, a...

change cell colors after comparing against an answer row
I have users' answers in multiple rows. my top row has the right answer keys. Each column represents answer to a question. How can I compare the all the rows against the right answer keys and give a highlights on all the wrong answers? A1 to A10 is the right answers for question 1 to question 10: B,D,D,D,A ,B,A,A,B B1 to B10 is the answers from one user. In the example blow, I'd like to compare 2 rows and highlight the B2 cell in yellow (for it's the wrong answer) B,C,D,D,A ,B,A,A,B .... continue with the rest of users. How can I do that? Thanks, Select B1:Z10 (or through th...

Display a summary sheet, for several tabs
I have an Excel 2003 spreadsheet that had 12 tabs on it, one for each member of the team. On this tab, they record details of specific calls that they have taken, including the date that the call was taken on. What I want to do, is include a summary tab that will show for all tabs, the date and the summation of all financial values from the tabs. So, for example, if the first three tabs show the following information: Tab Date Written Off Original New 1 10/10/2008 250.00 6.00 5.00 1 10/10/2008 175.00 25.00 ...

Reference to content AND formating of target cell
Hi. A1: =I am the <b>best!</b> (<b>...</b> means bold letters) A2: =A1 Returns: =I am the best! (without bold) What can I do so that the exact formating (eg bold, font size, font color, backgorund colr etc.) will be preserve as well? -- Additional information: - I'm using Office XP - I'm using Windows XP conditional formatting. "Ninja Stevie" <stevie.holmes@gmail.com> ??? news:1126134516.995378.263860@o13g2000cwo.googlegroups.com ???... > conditional formatting. > Sorry, but how is it possible to do what I want by conditional ...

text bo x with value from cell on other sheet
I have a chart - at bottom of chart I have cells with value form other sheet. I am trying to ficx chart someone else made. Can I pout a cell reference to another sheet in atext box to get alignment To get a textbox with a cell reference, select the chart, type an equals sign, then select the cell with the mouse. If the cell is on another sheet, you can navigate using the sheet tabs. If it's in another whole workbook, navigate using the Windows menu. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ ___...

Copy cell to another worksheet
Hello I am populating cells C5 thru C100 on my sheet Case Report. I woulld like the same information to populate my Time sheet in the A1 thru A95 range automatically. Is this possible? Thanks Bob This is possible, but the cells what you selected must be continuous. -- ===================================================== * �����ഺ���ٵ�ʱ���и�Ů��ԸΪ��ȥ���� ���� * * ����־�ᶨ�ض���˵����Ҫ���ٲ����ң��Ҿ�ȥ���� * * ���������ʵ���ʱ���и�Ů��Ը���ҹ�����Ȫ������ * * ��ն�������Ķ���˵�����ٲ���Ǯ���Ҿͺ���ͬ���ھ���* * * * �Ž�ƽ ...

Company Name Problems / SBS
I'm installing standard on a new Win2K Small Business Server from the Action Pack I sent in the Activation and was given a key for "Riddle, Inc." Install tells me the Riddle, Inc. already exists and I saw other posts indicating the chars like ".," are a problem. Do I need to request a new Company/Key? Looks like uninstall reinstall is required to change name (with manual SQL deletes)? ---- Also I have MSDN which I'm told has Pro. How to I get a key for it? How can you tell one distribution from the other? Both just say CRM Server 1.0. Is the difference just the...

Display results based on a date range
Hello, I’m trying to creating a form that will display info from my table called “tblCalls”. I would like the info to be display between to a “Date” range entered by the user. Within my “tblCalls” there is a field that contains the date of each record. In my form called “frmCallLog” are the two textboxes, in which the user will enter the desired date ranges “Calls from [textbox “8/20/06”] through to [textbox “8/20/07”].” The form will then auto populate with the results. There are many textboxes that will at that time auto populate with results, such as, how many times does “Jason”, “Bob”...