View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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