LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Function to Insert Text Into a Formula

I need a way to get text from a cell put into a function such that the text
fills in the name of the worksheet to look for the data in.

i.e. I want to look for cell B2 in worksheet test, then the next cell down I
want to look for cell B2 in worksheet answer, etc but I don't want to have to
modify the formula to input the worksheet name every time. I want a way for
the worksheet name to be grabbed from an adjacent cell and populate the
formula that already has the cell B2 in it.

Thx.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I insert a formula in a cell,which contains some text Smitha Roney Excel Discussion (Misc queries) 5 July 9th 07 01:26 PM
Insert text in a formula petbi Excel Worksheet Functions 2 June 26th 07 09:43 PM
How to Insert function right on text values e.g. 0180001640 Norm Genest Excel Worksheet Functions 1 May 18th 05 05:51 PM
How to Insert function right on text values e.g. 0180001640 Gary Brown Excel Worksheet Functions 0 May 18th 05 05:26 PM
how do I insert a function that chooses between two text values? Gailwdz Excel Worksheet Functions 5 May 4th 05 07:36 AM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"