View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How do I use a formula result in another formula

Yes it is, but perhaps you can post a copy of your formula here and describe
your data layout, so we are better able to help you?

Pete

"Maureen" wrote in message
...
Trying to use vlookup where the column in the array in which we are trying
to
lookup the corresponding value is the result of a formula. The formula
being
used is left, cutting the 16 digit number down to 15.

Is it even possible to use the value of a formula in another formula?