Vlookup using a formula possible?

[Guest]

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

 

[Bob Phillips]

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)