Results 1 to 6 of 6

vlookup/match/index function?

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2006
    Posts
    62

    vlookup/match/index function?

    Ok so right now I have two formulas that I am using as I have two different charts.

    In cell D3: =VLOOKUP(B1,B8:G11,HLOOKUP(C3,B6:G7,2,FALSE),FALSE)
    Using the data in B6:G11

    In cell D4: =INDEX(D15:D27,MATCH(1,IF(B15:B27=B1,IF(C15:C27=B4,1)),0))
    Using the data in B13:G27

    In cell C3 I have a list and can use the drop down and D3 will automatically change the data in D3.

    That’s what I want for cell D4 too, but I have both cell B4 and B5 that I want to use as drop downs.

    Does anybody have any ideas? Just an fyi I have downsized my data to simply things.

    Thanks
    Attached Files Attached Files

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