LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Please can you help. I can not remember what the special formula step is.

some time ago a friend made a graph on a sheet for me.

Now he did something that to this day I have been unable to recall or find
any documentation on, I can not even remember what is did in the sheet or
how it worked.

All I know is all the formula did not work until he did this step.

I would imagine this will be easy if you know what it is this if just an
example not the actual code.

The actual code used a number of if statements in it if I remember
correctly.

Now this was the trick

The STD Code would look like this below.
=VLOOKUP(Sheet2!A1,Sheet3!A:E,2,0)


He then pressed two keys wile in the formula and the formula then looked
like this.
Note " at the beginning and the end.
The formula did not work until he pressed the key combination and the
formula was placed inside " ********* ".

"=VLOOKUP(Sheet2!A1,Sheet3!A:E,2,0)"

Can you explain this step and what is was doing.
Where is the documentation to this process in excel I am sure it must have a
name.

Note
Just placing the formula inside " " does not work you have to press this key
combination like ( Eg ctrl,shift,f2 ) this is not the actual key comb,

Thanks for your help.

Rick


 
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
Need step by step to add invoice numbering to excel template rmt New Users to Excel 4 July 6th 08 11:45 PM
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 1 June 15th 06 09:24 PM
Need step by step instructions to try, not a demo. Can't remember [email protected] Excel Worksheet Functions 0 June 15th 06 10:05 AM
What is the step-by-step procedure for making a data list? Bobgolfs56 Excel Discussion (Misc queries) 1 April 23rd 05 02:19 PM
I need step by step instructions to create a macro for 10 imbedde. diana Excel Worksheet Functions 3 January 31st 05 01:56 AM


All times are GMT +1. The time now is 01:19 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"