Vlookup & matching

[Katiek9]

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)

[ratcat]

G'day Katie

and welcome to the forum.

Try this

Please Login or Register  to view this content.

If this does not help, upload an small example.

Cheers

[ratcat]

....

Please Login or Register  to view this content.

..........

Sorry just spotted a typo the formula

try this

Please Login or Register  to view this content.

You may have to adjust your col index num in the Vlookup formula. That's how many columns your looking across from A7. At the moment your looking 4 columns across, so the formula is looking in col D to return value.

Cheers

[Katiek9]

Thanks RatCat!