+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP to return value from table dependent on 2 variable fields/values

  1. #1
    Forum Contributor ndtsteve's Avatar
    Join Date
    05-01-2012
    Location
    Guildford, Surrey, England
    MS-Off Ver
    365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit
    Posts
    104

    VLOOKUP to return value from table dependent on 2 variable fields/values

    Firstly, can I say that I am not sure if VLookup is the correct way to go about this problem. I am a beginner in vba so please bear with me.

    See attcahed file which is example of what I aim (with assistance ) to achieve.
    Depending on 2 variables, Size and Area, I want to lookup and report value to another box on the same page.

    Example: Size = 6 (looks down col A to find 6 @ Row 2) then Area = Malaysia (which then looks across Row 2 to find Malasia in Col F) and return the value where these two meet (552.00)........hope this makes sense!

    Thanks in advance
    Steve

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: VLOOKUP to return value from table dependent on 2 variable fields/values

    Steve - perhaps this formula will do the trick?

    =INDEX(B2:M25,MATCH(B28,A2:A25,0),MATCH(C28,B1:M1,0))

  3. #3
    Forum Contributor ndtsteve's Avatar
    Join Date
    05-01-2012
    Location
    Guildford, Surrey, England
    MS-Off Ver
    365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit
    Posts
    104

    Re: VLOOKUP to return value from table dependent on 2 variable fields/values

    @ StephenR, you are a star been trying for an hour to work this out! Thankyou very much

+ 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