Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Annual leave | Excel Discussion (Misc queries) | |||
Trying to get annual savings | Excel Discussion (Misc queries) | |||
Calculating rents and months past in 1 cell??? | New Users to Excel | |||
Calculating rents and months past in 1 cell??? | Excel Discussion (Misc queries) | |||
Annual Leave | Excel Discussion (Misc queries) |