Results 1 to 4 of 4

Vlookup & matching

Threaded View

  1. #1
    Registered User
    Join Date
    12-02-2008
    Location
    dallas
    Posts
    5

    Vlookup & matching

    I have a spreadsheet that looks like this:

    A B C D E F
    1 Scenario A Scenario B Scenario C
    2 Studio 15 20
    3 1Bed 15 20
    4 2Bed 15 0
    5
    6
    7 Scenario A Scenario B Scenario C
    8 Studio 5% 10% 15%
    9 1Bed 10% 15% 20%
    10 2Bed 15% 20% 25%


    RIght now my formula For Cell D2 is

    =IF(C2=0,(B2*-$D$8),0)

    I need the formula to Match what is in Column A and Also what is in Row 1 to what is in the table (C7:F10)
    Last edited by VBA Noob; 12-02-2008 at 05:10 PM.

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