Results 1 to 6 of 6

vlookup/match/index function?

Threaded View

fastballfreddy vlookup/match/index function? 06-14-2008, 01:11 AM
ratcat G'day Freddy, Yes I may... 06-14-2008, 05:20 AM
fastballfreddy I can't believe I did that.... 06-14-2008, 12:08 PM
olasa One solution 06-14-2008, 02:18 PM
fastballfreddy thanks!!! 06-14-2008, 02:35 PM
olasa .. 06-14-2008, 05:21 PM
  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