Results 1 to 4 of 4

VLookup with Multiple Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2007
    Posts
    4

    VLookup with Multiple Criteria

    I've tried figuring this on my own but it is about a half step too advanced for my current working knowledge. I have a table that details which Agent should be selected for a particular city, and what the secondary Agent would be. So the information I want displayed is:

    City: ATL
    Primary Agent: Atlanta's Best
    Secondary Agent: Dunghill Farmers

    The sheet the information is stored in is organized as follows:
    Column A: City
    Column B: Agent Name
    Column C: Rank (1, 2 or 3)

    So what I need is:

    When I type ATL into Cell A2, I need Cell B2 to return the Agent ranked 1, and Cell C2 to return the Agent ranked 2.

    I think I need VLookup for this, but I can't figure out how to use it with 2 criteria, meaning I need to check the City the Agent is coded for (ATL) and the Ranking (1) to return Atlanta's Best into cell B2.

    See attached for further detail. Thanks!
    Attached Files Attached Files

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