Results 1 to 11 of 11

Multiple Criteria - Vlookup for numerical values

Threaded View

  1. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Multiple Criteria - Vlookup for numerical values

    You don't state where your table is located, let's say for args sake the table is located in A1:D9, to retrieve column C value (0.4):

    =LOOKUP(2,1/(($A$1:$A$9=30)*($B$1:$B$9=1800)),C$1:C$9)
    copy this to next column so as to retrieve column D value (3)
    Obviously references to 30 & 1800 can be to cell references containing those values of interest.

    Going forward please also specify XL version either in your profile or in your post.
    Last edited by DonkeyOte; 08-28-2009 at 05:11 AM. Reason: edited per arthurbr's catch (post # 5)

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