if 2 cells match then enter 3rd cell

I have a summary of my rent roll and it has many columns and rows. I would like to make a chart that shows something like this - If column a =1, and column b = 3 then +Column K(cell number on row to match the true statement for column A & B. Does that make sense? If row 5 has column a = 1 and column b = 3 then I want K5 in that cell.

Thanks in advance.

=IF(AND(office!A:A=2,office!B:B=1),INDIRECT(OFFICE!"K" & ROW())),"")

This is what I have and I get an error highlighting the "K"

=IF(AND(office!$A:$A=6,office!$B:$B=1),INDIRECT("OFFICE!*K" & ROW()),"0")

It doesn't work with the * sign either.

table2.JPG This is what I want to accomplish
table 1.JPG This is my data table.

As you can see I can pull some of the data correctly but not all of it. The formula that works sometimes is: =IF(AND(office!A:A = 6, office!B:B = 1),office!K:K,0) but it doesn't work all the time. (of course I change what A and B equal to match what I need)

My data is the table in blue - I want to search column A for a number, and column B for a number if both are true I want to put the corresponding value that is in column K on my data sheet, the yellow table. For example if in the same row, column A (flr) = 6 and Column B (tier) = 1 then I want the value for K ($/sf) in that row to be put on the yellow spread sheet; for this example both floor 6 and tier 1 are true and the value in K for that row is 25.02.

Description: Floor and Tier rentroll

You can use the following link to retrieve your file:

https://www.sendspace.com/file/i7mna0

Here is the file. thank you.

Yes, thank you, it worked! I appreciate your help.

I have been using your formula and it seemed to be working but it really wasn't - it was working because there was only 1 suite on each floor that had a specific tier. If there are 2 suits on the floor with the same tier suite it simply gives me the product of the two suites, but I need the average of the suites on each floor.

For example on 1 floor there may be 5 suites and there may be 5 different tiers so the $psf is simply the sum per our formula. If a floor had 5 suites but 2 suites have the same tier # then I need the average of the $psf on my chart not the sum of the two suites $psf.

I actually figured this out so no need to answer anymore.

Thanks!