1
  • 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 in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 pointsBadges:
  • Vlookup Formual in VB

    I have the following code that keeps being displayed as "run time error 1004 for application or object defined error. Sub formula() Sheets("Depletions").Activate Range("G8:G156").formula = "=IF(IF(ISERROR(VLOOKUP(B8,'Banfi DA '!$D$5:$P$266,7,FALSE)),"",VLOOKUP(B8,'Banfi DA...

    Hayd26715 pointsBadges:
  • Linking Information in two seperate Workbooks

    I need to create a Workbook that has certain cells accessible for people to enter in thier information and then have the ability to pick from a drop down list that will autopopulate a name beside the job number chosen. I have managed to do this using V lookup however the main source Workbook opens...

    CleanEnergy5 pointsBadges:
  • Problems using VLOOKUP

    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:
  • Can i use VLOOKUP if table array contains only parts of strings from lookup value

    -Column A contains whole bar code number (combination of numbers & letters,15-23 characters lenght),column has 1000 rows & there can be duplicates in it. -I need to use column D is array (109 rows) containing only midle parts of the bar code number witch lenght allso can vary by number of...

    Axe65 pointsBadges:
  • Excel 2003 ranking with VLOOKUP

    I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy Heart 46% 24%...

    Jha9005 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:
  • Is vlookup the correct formula to use for my task?

    This is the formula that I am trying to write: When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that does not match with vendor...

    Ginaque5 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