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