How do I use a formula result in another formula

[Maureen]

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?

 

[Pete_UK]

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

 

[MartinW]

Hi Maureen,

As we all know the help file is not always helpful. But
if you read it correctly it can be a fount of knowledge.

Take the following exerpt from the help file for example.

Syntax is.
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value is the value to be found in the first column of the array.
Lookup_value can be a value, a reference, or a text string.

It says Lookup_value can be a value and a value is what
a formula returns, therefore the lookup_value between
( and , can be any formula that returns a value.

HTH
Martin