How to place the Sale Income in the correct Monthly Cell

[excelbetter]

I have a workbook that has two tabs.

Tab 1 = Selling price and selling month (i.e. in A1 I have the month #, in A2 I have the selling price of a house)

Tab 2 = Columns for month 1,2,3, etc all the way out to month 24. (i.e in A1, etc I have month #, and in A2, etc I want the selling price value based on the month the house was sold, driving by the data in Tab 1

I am trying to know the formula to put on Tab 2, in the first 24 columns, that would reflect the selling Month and Price from Tab

Meaning, if I tab 1 it shows we sold a house in Month 6 for $100,000, on tab 2, in the 6th column, row 2, it would show $100k

Thank you for any help.

TY

 

[nikio8]

why not use pivot table?
month as columns, house name as rows, price as value ?

 

[excelbetter]

why not use pivot table?
month as columns, house name as rows, price as value ?

Good idea, but I can't do that as my question is part of a much more complex spreadsheet whereby I can't use a Pivot Table. I need to do some form of a lookup and place the value from Tab 1 into the correct cell on Tab 2

 

[nikio8]

you can try special paste - transpose? or sumifs, second criteria would be absolute reference, tab2 heading.

would be great if you had some sort of data to show exactly what you need.


why not pivot table? you can still reference B5 in pivot table or whatever in your further formulas?

 

[excelbetter]

you can try special paste - transpose? or sumifs, second criteria would be absolute reference, tab2 heading.

would be great if you had some sort of data to show exactly what you need.


why not pivot table? you can still reference B5 in pivot table or whatever in your further formulas?

I was hoping there was some Match or Index or Lookup way of doing it.