Vlookup using a formula possible?
 

Hi

I have used right to get rid of the first number in a cell. When I try to do
a lookup with this formula Excel returns N/A.

Is it not possible to use a cell with a value returned from a formula as
lookupvalue?

Sverre

Vlookup using a formula possible?
 

Probably looking for a string in a set of numbers, try this approach]

=VLOOKUP(--G1,K1:L10,2,FALSE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sverre" wrote in message
...
Hi

I have used right to get rid of the first number in a cell. When I try to
do
a lookup with this formula Excel returns N/A.

Is it not possible to use a cell with a value returned from a formula as
lookupvalue?

Sverre