How can I do this

Luanita7

New Member
Joined
Aug 3, 2012
Messages
44
Sheet 1
HOUSE
PRICE
SF
501
$11
1200
502
$12
1300
503
$13
1250
504
$14
1300

<tbody>
</tbody>

SHEET 2
HOUSE
PRICE
SF
GAL
HR
501
11$
$1200

<tbody>
</tbody>

Good mornig.
I will appreciate if someone can give me a little help with this, Is there a formula that allows me to just typing the house number on sheet 2, bring all the house information from sheet 1, such as prices ans sf.???

Thank you very much
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
VLOOKUP will do it.

You want something like this in Price:

VLOOKUP($A2, Sheet1!$A$1:$C$5, 2, FALSE) for price, assuming HOUSE in both sheets is A1

If you include the $ signs like here, you can drag the formula around the remaining cells

2 in the formula above is the column number relative to the left most column of the range (A1:C5) i.e. it is the second column
 
Last edited:
Upvote 0
Hi and welcome to MrExcel.

You will need a Vlookup.

Based on this sample data....

Excel Workbook
ABCD
1HOUSEPRICESF
2501111200
3502121300
4503131250
5504141300
6
Sheet1


Result.....

Excel Workbook
ABCD
1HOUSEPRICESF
2501111200
3
Sheet2


The formula in B2 needs to be copied across.

IF you have a larger data range than the one above, just change the cell range $A$2:$C$5 to suit your layout.

I hope that helps.

Good luck.

Ak
 
Upvote 0
Happy to help :)

Dont forget to update the 2 to the column you want to return, for example for SF change 2 to 3.

There is a limitation to this formula, that the value you are searching for has to be in the first column, but for this case you are fine.
 
Upvote 0
Hi Luanita7,

I'm pleased you have the solution you wanted, thanks for the feedback. :biggrin:

You now know where to come for all your Excel problems, MrExcel, the best Excel site on the net. :biggrin:

Ak
 
Upvote 0

Forum statistics

Threads
1,213,532
Messages
6,114,176
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top