Extract cell reference from formula

inwhack

New Member
Joined
Jul 16, 2012
Messages
1
I have a cell reference "=H47" as a formula in a cell F11. This refers to some data in a table below and reproduces the name of a person in cell H47. In cell F12 I want to put the phone number from cell H49 (two cells over from the name). How do I extract the "H47" from the formula in cell F11 so I can add two to make H49 and paste it in cell F12 as "=H49"?? I want to do this, so that I can simply substitute a different name in the table into cell F11 (say =J47) and have the phone number automatically switch to J49 so it relates to the new name. Or can I only do this through VB or a macro? Thanks
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Jerry Sullivan

MrExcel MVP
Joined
Mar 18, 2010
Messages
8,787
Hi and Welcome to the Board,

Have you considered using a lookup formula in F12? (perhaps Vlookup or Index-Match)

That would be a simpler and more conventional approach to looking up a phone number associated with a name.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,530
Messages
5,602,190
Members
414,513
Latest member
junbuggle

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
Top