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?

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?

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,ra nge_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



"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?