View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Albert
 
Posts: n/a
Default Reading formulae in a different cell

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