1
  • Problems using VLOOKUP in Excel 2003 spreadsheet

    I have an Excel 2003 spreadsheet that contains a Volunteer Worksheet for the purpose of driving clients to doctors offices, and another Transportaion Worksheet that enters the dates and medical facilities to where clients will to be driven. I am utilizing a form, with a drop down list, to find a...

    Ironsprings5 pointsBadges:
  • EXCEL 2003 and VLOOKUP help in calculating percentage in third cell

    Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependent on which date range is chosen in Cell...

    Ianmax4975 pointsBadges:
  • vlookup

    how can I convert then match two lists of numbers?   One list has thousands of 7 digit numbers.   The other list is even longer, but contains all of the numbers in the first list, looking at the first 7 digits of each.   The difference is, the numbers have an additional digit on the end.

    Jkg5 pointsBadges:
  • Vlookup repeated dates

    I have a spreadsheet (A) with various data, where one column contains variuos dates, and one column with values. I want to be able to distinguish all values for each year, so I have another spreadsheet (B) with a long list of all dates for 2010, 2011 and 2012.  I use vlookup...

    Msva5 pointsBadges:
  • VLookUp

    In a vlookup, what do I type in the formula so it shows “err” or something that indicates that the EXACT match is not found in the table?

    BillOZ5 pointsBadges:
  • Vlookup Worksheet Function

    I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

    Hunter115 pointsBadges:
  • Help with a macro for linking a data entry form spreadsheet to the results spreadsheet

    I am entering seminar selection data for 600 students and i have a spreadsheet with names and id numbers. there are 20 seminars that they may attend and they have "ranked" them 1-20. I would i have a data entry sheet with a VLOOKUP that will find the student (on the second sheet) and display the...

    JBH18555 pointsBadges:
  • Match a date to a number

    I have a list of dates (A) on the left inside next to each date i have numbers (B). I have another list of dates (C) which is shorter with the same dates. I'm trying to match the numbers to dates (C) based on the first dates (A). 1 0.6 10/20/08 10/20/08 2 1 10/21/08 10/21/08 3 0.65 10/22/08...

    Cubemonkey5 pointsBadges:
  • Multiple VLOOKUP with multiple results

    There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to...

    Excelaccountant20 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following