Vlookup using a formula possible?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
Back
Top