i can'r seem to rememebr how to add a value lookup in excel to make more options to choose from in a cell?
970192
I thought I was pretty handy with excel, but I have no idea what you're asking! Do you mean the options pop-up you get if you right-click on a cell? Or Insert > Function? (on the pull-down menu, or click on the 'fx' button just below your toolbar/s). Perhaps if you clarify your question you might get a more helpful answer than I feel I can give you.
1103350
excel is not that usefull for this. You basically have to write a VBA program that will go like this:\n\nif cell-value=111222 then cell-value="johnny"\n\nand so on for every contact you have. While thi is not hard there are better ways to do this. There are Address book programs that let you search by any field.
881205
VLOOKUP is used for lookup tables in which the compare values are placed in the table's first column. The general form is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]), where lookup_value is the lookup value you want to send to the table, table_array is the cell reference of the table, col_index_num is the number of the column in the lookup table containing the value you want to retrieve, and range_lookup indicates whether the compare values constitute a range of values or an exact match.
404712
You can do this by VLOOKUP\n\nSheet 1 contains the full list \nSheet 2 your item codes\n\nIn Sheet 2.\nB2=VLOOKUP(A2,Sheet1!A1:C3,2)\n\nThis looks up the value in A2 in the range A1:C3, and returns the second column (B).
1059707
As much as I know about Excel, I have never seen the ability to do that. Your best bet would be to Merge multiple Cells in 25-50. This is about the only way to get the desired effect but it isn't exactly what you want to do I am guessing.
190763
GETPIVOTDATA does get in the way...\n\nEither type the cell reference directly, or select another cell outside the table then click and drag it into the pivot table to the cell you want to refer to.  No other way round it I'm afraid!
317497
This may be overly symplistic, but if it were me, I'd open up both files at the same time and just link from one file to the other as if I were linking between worksheets.  That way excel creates the full path for you.  You could do that for one cell, then do a search and replace for all of the others.
828527
Create a table in Excel with the first column containing the number and the second column containing the word related to the number.  Then use vlookup to read in the figure and output the word.\n\nFor example, assuming that you want to replace values from 1 to 5 with words, your lookup table is as follows (with a range name of figure_lookup:\n1One\n2Two\n3Three\n4Four\n5Five\n\nCell A1 contains the number 1, then your formula is =VLOOKUP(A1,figure_lookup,2)  where A1 is the value being looked up in the table called figure_lookup (could also use cell references such as B5:C9), using the 2nd column.\n\n\nAnother option:\nOr a much more elaborate way to do this is with Visual Basic.  Details are at:  http://www.ozgrid.com/VBA/ValueToWords.htm
241133
It fixes the column or row reference.  \n\nFor example:\n\nLet's say you put "=a1+b2" in cell c2, then copy that to c3.  In cell c3, you would get "=a2+b2".\n\nOn the other hand, if you put "=$a$1+b2" in cell c2, then copy that to c3, you would get "=$a$1+b3" in cell C3.\n\nYou can use the $ in either the row or column part of the reference.  Another example:\n\nIf you put =a1+b2 in cell C2, then copy that to cell d3, you would get =b2+c3 in cell d3.\n\nIf you put =$a1+b2 in cell c2, then copy that to d3, you would get =$a2+c3.\n\nIf you put =a$1+b2 in cell c2, then copy that to d3, you would get =b$1+c3.\n\nBest way to see how it works is to play with it some.
55468
your function would be =CONCATENATE("""", <field>, """")\n\nif you want the data to be in the same fields, you may need to use multiple sheets.
787937
This example sets the value of the cell A1 with the answer to a messagebox with Yes and No options:\nDim Msg, Style, Title, Response, MyString\nMsg = "Is that ok?"    \nStyle = vbYesNo + vbCritical + vbDefaultButton2\nTitle = "Question"\nResponse = MsgBox(Msg, Style, Title)\nIf Response = vbYes Then    ' User chose Yes.\n    MyString = "Yes"\nElse    ' User chose No.\n    MyString = "No"\nEnd If\nActiveSheet.Cells(1, 1).FormulaR1C1 = MyString\n\n\nAnother example: User enter a value for the cell A1,using InputBox:\n\nDim Message, Title, Default, MyValue\nMessage = "Enter a value for the cell A1"\nTitle = "Value for A1"\nDefault = ActiveSheet.Cells(1, 1).FormulaR1C1 ' Get the previous value from the cell\nMyValue = InputBox(Message, Title, Default)\nActiveSheet.Cells(1, 1).FormulaR1C1 = MyValue 'Set the new value for the cell
102604
I am assuming that you are using Excel.  Highlight your cells and click Format->Cells on menu bar.  Change from text to Number.
72978
I'd use the vlookup function.\nInsert another column between the 2 you have, then (thinking that you'll have column headers) in b2 =vlookup(a2,C:C,1,false) this will bring back the value if you have it in the second set (which should now be in col C). Paste it to the bottom of your data set.\nCopy the formula into col D, & paste down.\nI'd then sort by col B then by D. What's matched is good, what isn't is unique to the column.\nHope this helps
681635
let say that\n1) your database is in Sheet2 from a2 to c20... where column"A"a is the ID, "B" is product and "C" is the cost\n2) in Sheet 1 you need the formulas next to the cell where the user enter the ID, for example cell A1... so you enter the following formulas\nTo get the product in cell B1  =VLOOKUP( A1 ,Sheet2!$A$2:$C$20 , 2 , FALSE )\nTo get the cost in cell C1  =VLOOKUP( A1 ,Sheet2!$A$2:$C$20 , 3 , FALSE )
544272
File.. Get External Data.. Link Tables .. browse to the xls file    would set up a permanent link to the excel data and give the spreadsheet a kind of table name. Then it can be queried. You want to use several columns over time and you can use an 'Append query' to append data to a table; but experiment with a crosstab query. In that way, your Access table would always have 2 fields plus maybe a ColumnNumber field where you could have a default value of 1 the first week, 2 the next week, etc.. A crosstab query would present that data as several several columns (one for each ColumnNumber value). When your Access skills increase, you might be very glad that you used a small number of fields because it makes the querying of the data simpler to maintain, in my opinion.\nAs for VLOOKUP, you can research "query table joins" and see how a query in design view lets you choose the field which 2 tables have in common. One table is really the excel spreadsheet presented as if it is a table; the other table is the real access table.
610232
Make one on a spreadsheet
296667
Vlookup isn't that hard once you know how it works.\n\nLet's see if I can show you here...\n\nYou have 4 columns...\n\n.. A.. B.. C.. D\n1.. 1.. =vlookup(A1,C1:D4,2).. 1.. One\n2.. 2.. =vlookup(A2,C1:D4,2).. 2.. Two\n3.. 3.. =vlookup(A3,C1:D4,2).. 3.. Three\n4.. 4.. =vlookup(A4,C1:D4,2).. 4.. Four\n\nThis will render the output...\n\n...A..B.....C...D\n1..1..One...1...One\n2..2..Two...2...Two\n3..3..Three.3...Three\n4..4..Four..4...Four\n\nIn vlookup, the first variable (A1) says "Here is the value I want you to look up in the table"\n\nThe second value, (C1:D4) says "This is where the table is"\n\nThe third value, (2) says "When you find a match in the first column, use the output from the second column"\n\nSo, in the first line (=vlookup(A1,C1:D4,2))\n\nIt says Look up the value in A1 (1) in table C1-D4 and display what you find in the second column.\n\nSince the value of A1 is "1", it finds "1" in C1 and displays whatever is in the second column, which is "One".\n\nSimple huh?  You can find more information here...\n\nhttp://office.microsoft.com/en-us/assistance/HP052093351033.aspx