Need to figure out Annual Rents

[TJehn]

I have reexamined the answer and I am still unable to get this to work.
I have a simple table with a city and address, List Price, Bedroom, Bath and
Square footage.
This table has several entries updated frequently.
Conceder the table to begin at A1.

I have another table that lists market rents.
This table for the most part is static.
Conceder the table to begin at A10.

I need a formula in cell “A7†to look up the city in A column and the number
of bedrooms in the D column and match it in the “Market Rents†table to
return the annual rents (A7).

Thanks for looking at this again


City Address List Price Br. Ba SF
City1 21 Woodridge Pl City1, CA 94101-4150 $254,900 3 2 1519

Annual Rents 1 2 3 4 5
City1 $11,901 $12,539 $17,582 $21,654 $24,905
City2 $12,020 $13,792 $19,343 $23,825 $27,400

 

[ShaneDevenshire]

Hi,

Try this formula

=INDEX($B$11:$F$12,MATCH(A2,$A$11:$A$12,0),MATCH(E2,$B$10:$F$10,0))

where the first city in the bottom table is in A11 and the first number of
BR is in B10.

If this helps, please click the Yes button.

 

[TJehn]

I pasted it in and now I get how it is suposed to work. Thanks. (The
bedroom coulmn is the D column) However, I get a #N/A as a result.

My login name at hotmail.com

Thanks again.