|
|
|
|
05-04-2006, 05:45 PM
|
#1 |
Microscoft Excel
If cell A1 contains a formula e.g. =Vlookup(50,RANGE,2)=99.45 say, how can I
reference or find the 3rd argument in the formula from another cell. When I use any formula that references A1 it always uses the result of the formula (99.45 here) and not the text of the formula ( =vlookup(50.RANGE,2) ). Thanks -- Albert =?Utf-8?B?QWxiZXJ0?= |
|
|
|
05-04-2006, 10:57 PM
|
#2 |
|
Posts: n/a
|
Re: Microscoft Excel
Please repost your question in the Excel newsgroup:
http://www.microsoft.com/office/comm...ang=e n&cr=US -- Carey Frisch Microsoft MVP Windows - Shell/User Microsoft Community Newsgroups news://msnews.microsoft.com/ ---------------------------------------------------------------------------Â*---------------- "Albert" wrote: | If cell A1 contains a formula e.g. =Vlookup(50,RANGE,2)=99.45 say, how can I | reference or find the 3rd argument in the formula from another cell. When I | use any formula that references A1 it always uses the result of the formula | (99.45 here) and not the text of the formula ( =vlookup(50.RANGE,2) ). | | Thanks | -- | Albert Carey Frisch [MVP] |
|
|
 |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VB with excel | sanju | Software | 0 | 04-02-2008 06:14 AM |
| Save an Excel file, created from a DataGrid, programmatically.. | tapasmahata | Software | 0 | 01-12-2008 05:39 AM |
| How to run a Excel Macro from the Java application? | Kiranu | General Help Related Topics | 0 | 09-12-2007 02:11 PM |
| Uploading Excel file into sql table | shalim | Software | 1 | 10-31-2006 08:57 AM |
| DVD Verdict reviews: EXCEL SAGA: IMPERFECT COLLECTION and more! | DVD Verdict | DVD Video | 0 | 09-02-2004 10:08 AM |
