Need to figure out Annual Rents
 

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

Need to figure out Annual Rents
 

Hi,

Try this formula

=INDEX($B$11:$F$12,MATCH(A2,$A$11:$A$12,0),MATCH(E 2,$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.
--
Thanks,
Shane Devenshire


"TJehn" wrote:

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

Need to figure out Annual Rents
 

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.

"ShaneDevenshire" wrote:

Hi,

Try this formula

=INDEX($B$11:$F$12,MATCH(A2,$A$11:$A$12,0),MATCH(E 2,$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.
--
Thanks,
Shane Devenshire


"TJehn" wrote:

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