+ Reply to Thread
Results 1 to 8 of 8

Vlookup with two criteria

Hybrid View

mkvassh Vlookup with two criteria 10-22-2009, 07:22 AM
zbor Re: Vlookup with two criteria 10-22-2009, 07:26 AM
mkvassh Re: Vlookup with two criteria 10-22-2009, 07:42 AM
NBVC Re: Vlookup with two criteria 10-22-2009, 07:48 AM
mkvassh Re: Vlookup with two criteria 10-22-2009, 07:56 AM
NBVC Re: Vlookup with two criteria 10-22-2009, 08:00 AM
mkvassh Re: Vlookup with two criteria 10-22-2009, 08:02 AM
mkvassh Re: Vlookup with two criteria 10-22-2009, 08:21 AM
  1. #1
    Forum Contributor
    Join Date
    11-02-2007
    Location
    Bryne, Norway
    MS-Off Ver
    Microsoft Office Excel 2010
    Posts
    230

    Re: Vlookup with two criteria

    I have the following content in column A, B and C

    Cost element Cost object Area
    709015 WTK.RND.0360.EN.EX Other
    972236 WTK.RND.0360.EN.EX Drilling & Production
    972261 WTK.RND.0360.EN.EX Drilling & Production
    979455 WTK.RND.0360.EN.EX Upstream Technology
    709015 WTK.RND.0360.EN.PR Other
    972237 WTK.RND.0360.EN.PR Drilling & Production
    972260 WTK.RND.0360.EN.PR Drilling & Production
    977745 WTK.RND.0360.EN.PR Project Development
    979456 WTK.RND.0360.EN.PR Upstream Technology
    979508 WTK.RND.0360.EN.PR Other
    709015 WTK.RND.0371.EN.EX Credit
    709015 WTK.RND.0371.EN.PR Credit
    I want to lookup the content of column C if there is match with the content in A and B combined. Lookup values for A and B will be in Z1 and Z2. An array function is OK.
    Last edited by mkvassh; 10-22-2009 at 07:44 AM.

+ 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