Posted to microsoft.public.excel.misc

JKBEXCEL

external usenet poster

Posts: 1

Extract Column Letter from Cell Reference in another Cell

Hi

I have a cell with references another sheet in the same workbook and I
would like to use place this column letter of the cell that is
referenced in a separate cell

Example:

In Worksheet 1

Cell A2 formula = 'Worksheet2'!D18
b2 desired value D

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumproduct issues	SteveDB1	Excel Worksheet Functions	25	June 3rd 09 04:58 PM
Using an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Conditional Format as a MACRO	Gunjani	Excel Worksheet Functions	3	March 29th 06 05:22 PM
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM

All times are GMT +1. The time now is 03:54 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us