Results 1 to 7 of 7

Vlookup with 2 parameters and multiple results

Threaded View

nmprodan Vlookup with 2 parameters and... 09-21-2012, 03:37 AM
Fotis1991 Re: Vlookup with 2 parameters... 09-21-2012, 03:43 AM
nmprodan Re: Vlookup with 2 parameters... 09-21-2012, 04:28 AM
Fotis1991 Re: Vlookup with 2 parameters... 09-21-2012, 05:21 AM
nmprodan Re: Vlookup with 2 parameters... 09-21-2012, 05:56 AM
Fotis1991 Re: Vlookup with 2 parameters... 09-21-2012, 06:00 AM
nmprodan Re: Vlookup with 2 parameters... 09-21-2012, 06:20 AM
  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Cleveland, OH
    MS-Off Ver
    2010
    Posts
    9

    Vlookup with 2 parameters and multiple results

    I'd like to find the row in the 'Table' sheet that contain both B2 & B3(first and last name) in the 'Names' sheet. The result would return the contents of the matching J (10) column in the cells from B5 and down if there are more than 1 result.

    The sheet is attached. I've tried many array formulas, but I'm having no luck.

    Thanks for any help, it's much appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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