Results 1 to 5 of 5

Need to match two columns and return a third column value from a table

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Need to match two columns and return a third column value from a table

    I have two columns in which I want to match BOTH columns to two columns in a table, and then VLOOKUP return the value from a third column in the table. But I'm not sure if this is possible...

    I have attached an example:

    On the left, I have two columns of data and the area where I want to have the VLOOKUP. On the right side is the table with 3 columns of data. I want to have A2 and B2 BOTH match to something in columns H and I AND return the value from column J. So if we look in the data, matching A21 & B21 to H & I the value should be Northwest Allied Physicians, but if we only have the one value (like normal VLOOKUP), this doesn't work and it returns OB.

    So is there a way to have the VLOOKUP check and match BOTH values before it returns a value?

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 12-16-2013, 04:02 AM
  2. Replies: 20
    Last Post: 04-15-2013, 01:06 PM
  3. Replies: 3
    Last Post: 05-24-2012, 10:10 AM
  4. Match 2 columns in 2 sheets and return the 3rd column
    By swadson in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-16-2011, 04:36 PM
  5. Replies: 6
    Last Post: 03-01-2011, 06:23 PM

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