Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Vlookup Problem (Excel 2003)

    Hi

    =IF(Range="B",VLOOKUP(B7,leadlook,9,IF(Range="C1", VLOOKUP(B7,leadlook,12,IF(Range="C2",VLOOKUP(B7,le adlook,15,""))))))

    Above is my formula, it returns as below I have checked the columns and they are correct

    If range is "B" the formula works,but if range is either "c1" or "C2" it returns FALSE instead of the number

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Vlookup Problem (Excel 2003)

    My guess would be that the closing parentheses are placed incorrectly. Does

    =IF(Range="B",VLOOKUP(B7,leadlook,9),IF(Range="C1" ,VLOOKUP(B7,leadlook,12),IF(Range="C2",VLOOKUP(B7, leadlook,15),"")))

    do what you want?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Vlookup Problem (Excel 2003)

    Hi

    Once again I am in your debt.

    Grateful Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •