Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Auto print a hyperlinked document
- I have set up hyperlinks in my Excel spreadsheet to Powerpoint. The hyperlinks are attached to a VLOOKUP table where the user picks one item from the VLOOKUP menu. I want to know if there is any way to have the item that is picked in the VLOOKUP...
- Tags: Microsoft Excel, Microsoft Office, Dhurlbut@..., VLOOKUP
- Discussion threads 2007-07-23
- Help With an Excel Formula
- I have created a spreadsheet for our little league baseball stats. I have different worksheets for each team (18 worksheets for 18 teams). I am trying to set up one of the Worksheets to have the league leaders in each category (i.e. home runs, hits, strikeouts, etc.) Is there a...
- Tags: worksheet, thomas.bowling@..., software, Microsoft Excel, VLOOKUP
- Discussion threads 2007-02-23
- Find a perfect match in a lookup table in Excel
- Using the FALSE argument in Excel can help you find a true match in a lookup table, while eliminating a lot of the confusion that is common with such comparisons. Mary Ann Richardson explains how to use the FALSE argument to your advantage. A lot of uses for a...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, VLOOKUP, exact match, Microsoft Office Suite Excel Tips Newsletter, Lookup, ID, Office Suites, Software
- Technical articles 2006-11-14
- Cell Values
- I am working on a quote form and have a table on the form with column headings 1,2,3,4,5 and row titles of a,b,c,d. As the user selects a $ amount in the table, I need to populate the $ amount in another cell. Can someone start me in...
- Tags: cell, Value at Risk, karabryan@..., software
- Q&A 2006-01-30
- Excel Data Comparison - Lookup
- I have two separate worksheets. Worksheet 1 contains a list of position #s personnel. Worksheet 2 contains a list of position #s Column A with individual names Column B. My task is to compare position #s in the two worksheets and when they match, copy and paste...
- Tags: Microsoft Excel, VLOOKUP, Worksheet, Carlos
- Discussion threads 2006-01-04
- Comboboxes and Excel: Autofilling a form
- A company that I recently started to work for wants to make a Excel or MS Access sheet that, when provided with a part number in a combo box or list, will automatically fill in three out of eight cells directly related to that information (specifically, model #, OEM, and...
- Tags: apathesia@..., cell, Microsoft Excel, part number, software, VLOOKUP
- Q&A 2005-12-13
- Vlookup
- Hi, i'm a student struggling with Vlookup i need a really slow step by step indepth instruction on how to use this function. I'm trying to return values such as customer name,code and so on (i have offered half the points i have because i am weary from searching the...
- Tags: VLOOKUP, lookup
- Q&A 2005-10-12
- Vlookup Crashes Excel
- Help!I am having a continual issue with the vlookup function in Excel 97 crashing the program.There is no real rhyme or reason to it, when a vlookup equation is written, sometimes it works and sometimes it doesn't.I have reinstalled Office many times and rebuilt the machine and the error still...
- Tags: excel, Microsoft Excel, Microsoft Excel 97, sambo1580, vlookup, Vlookup Crashes Excel, Vlookup Reply, windows
- Discussion threads 2005-08-16
- Use error handling to enhance your Excel spreadsheets
- If you're tired of seeing #N/A errors in your spreadsheets, we've got the solution for you. Find out how built-in Excel error-handling functions can hide these errors.In my two previous articles "Use this sample spreadsheet to make the most of Data Validation drop-down lists" and "See how our sample spreadsheet...
- Tags: Bob Johnson, Excel spreadsheet, cell, Vlookup, ISNA
- Technical articles 2001-04-02
- Get IT Done: Two tips for translating codes into meaningful terms in Excel
- Translate codes in Microsoft Excel into readable terms for usersAre there cryptic codes lurking in your Excel reports that might confuse your readers? Do they call and ask “What’s this abbreviation stand for?” or “Who’s agent 25?” Here are two tips to help you and your users convert those codes...
- Tags: Real estate, Sales strategy, Jeff Davis, Get IT Done, Microsoft Excel, Choose function, integer, Vlookup
- Technical articles 2000-02-24
Additional Resources
- Vlookup and word mailmerge
- Hi..I want to use vlookup command and and print letter using ms word..and that mailmerge shld pickup same row which is searched by vlookup command...Regards
- Tags: fanku@...
- Discussion threads 2006-11-03
- Excel 2003 formula
- I am having trouble with a formula. I am trying to write a formula that when someone selects an item from a drop down list in cell C14 that this cell will change to a corasponding number. I can't find any conditional formulas that will change from many...
- Tags: smugybear@..., Microsoft Excel, C14, Try VLOOKUP
- Discussion threads 2007-03-16
- Excel formula - copy cells from second worksheet
- Hi, I hope someone can help. I've got a workbook that contains a daily sales log, and the second sheet is a stock list with prices.In the sales log, Col. A is where the barcode data is entered (we've got that bit sorted) and Col. C is where the price...
- Tags: C/C++, Microsoft Excel, madison@..., cell, C
- Discussion threads 2007-11-01
- Excel 2002 Sample File: Lookup Function Sample Data (exe)
- Learn how to use Excel to use the VLOOKUP function to search through columns of data using these sample files. With the Lookup Function Sample Data spreadsheet, you can learn how to use Microsoft Excel to use the VLOOKUP function to search through columns of data. Excel 2002 Sample File:...
- Tags: Microsoft Corp., Microsoft Excel 2002, Microsoft Excel, Microsoft Office, Productivity, Office Suites, Software
- Software downloads 2007-10-02
- Excel 2003 Formula Question Calculating postage from weight
- I have a excel document that each product has a per piece weight and quantityi want to quantity*weight for gross weight then select a postage price a given set of weightsie 0 - 249 250-499 etcVALUESF7 QUANTITY G7 WEIGHTC1 LOW WEIGHT D1 HIGHWEIGHT E1 POSTAGE THROUGH TO C8 - D8...
- Tags: kryan@..., feedback, Microsoft Excel
- Discussion threads 2007-02-15
- Join Excel
- How can I merge multiple Excel spread sheets based on SSN field?Thankstry vlookup function
- Tags: career, ichu50, Join, Microsoft Excel
- Q&A 2004-11-01
- Excel 2000
- Greetings,My question is this, I am good with excel but I'm unsure what the max lenght of a formula is which is why I don't think this next thing can be done. Right now I have a friend who wants me to program a character sheet for a RPG he...
- Tags: F5 Networks, Michael34, Microsoft Excel, software, Use VLOOKUP
- Q&A 2005-04-23
- Vlookup ~ formatng
- I make quite extensive use of Vlookup & Pivot tables. Sometimes I run into problems when the LOOKUP cell and the table are not formated i thinkthe same.To clarify, I get a 'n/a' response in the formula, but when i copy and and paste the lookup cell to the table...
- Tags: cell, lookup, lookup cell, lookup value, Rafiki, software, Value at Risk
- Q&A 2004-10-06
- Excel Data Validation drop-down list
- Hi I'm new to this so I apologize in advance if I don't ask my question in the correct way. I'm using Excel 97 and I've created a data validation drop down list to be use in column A the actual list resides in column AZ.The drop down box...
- Tags: alf25, Microsoft Excel, software
- Q&A 2005-07-15
- DATA LOOKUPS IN EXCEL
- I want to be able to type in a name John Doe and have 2 values docket number and case number returned. I haven't used excel in while but I know there is a way to do this using the lookup function. Can anyone help and reply with...
- Tags: Microsoft Excel, E-mail, Microsoft Office
- Q&A 2004-10-11
- << Previous
- page 1 of 1
- Next >>
