+ Reply to Thread
Results 1 to 3 of 3

Nested VLookup, Match Formula Help Needed

  1. #1
    Registered User
    Join Date
    09-24-2009
    Location
    Phila, PA
    MS-Off Ver
    Excel 2003
    Posts
    28

    Nested VLookup, Match Formula Help Needed

    Trying to update a formula provided once before to now include additional criteria and failing.
    On Detail sheet in column K, looking to return values depending on specific criteria.
    On the detail worksheet, lookup name in column on the Contractor worksheet, return value from column D, if not found, return to detail worksheet and lookup project name in column A on the billable project worksheet & return value form column B, if neither of these, return to detail worksheet and lookup value in column G (Team) on the Names worksheet and return value in column E.
    Does this make sense?
    Attached Files Attached Files

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Nested VLookup, Match Formula Help Needed

    jealkon,

    Using your provided workbook, in sheet 'Detail' cell K2 and copied down, use this formula:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Nested VLookup, Match Formula Help Needed

    Hi jealkon,

    Try using below formula:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    see attached:- Excel Help 01-2013.xls

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ 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