+ Reply to Thread
Results 1 to 6 of 6

Vlookup - Country conditions (Multiple conditions)

  1. #1
    Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2013
    Posts
    890

    Vlookup - Country conditions (Multiple conditions)

    Hello Excel Experts,

    I have a situation with vlookup and hopefully you could help.

    Situation:

    In the attached file, I have 3 sheets - 'Vlookup-Data', 'Table' and 'ProductRate' where Vlookup-Data is where the result of vlookup will be, Table is where the Code is eligible for countries specified, ProductRate is where the rate of each product is.

    Thus, I need to do a vlookup getting the rate of 'sms' or 'voice' after it has done the initial check.

    Example1: Row4 of 'Vlookup-Data'. It is a 'T-Code..1' located at 'France'. Since 'T-Code..1' is a 'YES' on 'Table' Sheet, get the value of SMS in 'ProductRate'

    Example2: Row11 of 'Vlookup-Data'. It is a 'T-Code..2' located at 'India'. Since 'T-Code..2' is a BLANK on 'Table' Sheet, IGNORE any lookup.

    Hopefully I'm able to clearly explain. If not, I believe the attached file would be able to clearly show you what I want to accomplish.

    Thank you for your help and input!
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,130

    Re: Vlookup - Country conditions (Multiple conditions)

    hi dluhut. try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2013
    Posts
    890

    Re: Vlookup - Country conditions (Multiple conditions)

    Thanks Benishiryo!!!

    It works! Now, let me try to put that code together with my actual data that has other formula in it.

    Reps up for you! Please check!

  4. #4
    Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2013
    Posts
    890

    Re: Vlookup - Country conditions (Multiple conditions)

    Hi Benishiryo,

    I tried to modified the code a little, where in the real data, there's countries that are not listed in the 'Table' but were on the 'Vlookup-Data'.

    I tried to put ISERROR function on the code, but it's still giving me #N/A.

    Would you be able to help me out.

    Please Login or Register  to view this content.

  5. #5
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,130

    Re: Vlookup - Country conditions (Multiple conditions)

    you're very welcome. maybe:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    Excel 2013
    Posts
    890

    Re: Vlookup - Country conditions (Multiple conditions)

    Genius!!!

    Now I believe it's solved!

    I tried using the ISERROR function...when I separate them, it works, but when I combined, it doesn't...

    Anyway, thanks for your help Benishiryo!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1