# How can I do this

#### Luanita7

##### New Member
 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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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:
Thank you very much!!
Let me try!

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

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.

Thank you, Thank you, Thank you!!

Once again, Thank you!!!

Hi Luanita7,

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

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

Ak

Replies
1
Views
397
Replies
2
Views
285
Replies
3
Views
181
Replies
0
Views
262
Replies
1
Views
83

1,196,078
Messages
6,013,292
Members
441,760
Latest member
Sharina

### 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.

### Which adblocker are you using?

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

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