#### Hydestone

##### Board Regular
I am looking of for a simple worksheet to add feet and inches. Ie: column A has feet and column B has inches. Row 10 (?) would give you the result with feet in A and inches in B.

I can get the result in feet and inches in decimal format in the same cell, but now in separate cells.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### shg

##### MrExcel MVP
For example, ...?

#### Jonmo1

##### MrExcel MVP
Something like this maybe

#### macattackpro

##### Board Regular
Without an example of what you're looking at I can only guess with a possible solution:

Code:
``=A1&" ft "&B1&" in"``

Or if you're wanting a sum then:

Code:
``=SUM(A1:A9,INT((SUM(B1:B9)/12)))&" ft "&MOD(SUM(B1:B9),12)&" in"``

maybe

#### Hydestone

##### Board Regular
Jonmo1, macattackpro, and Scott T - Thanks guys. These are all great and work as I need them to!

John

You're welcome.

Replies
9
Views
240
Replies
1
Views
144
Replies
1
Views
917
Replies
0
Views
1K
Replies
9
Views
264

1,133,148
Messages
5,657,109
Members
418,355
Latest member
michaelirl

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