Thread: lookup values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Franz Verga
 
Posts: n/a
Default lookup values

Nel post
*Norman Jones* ha scritto:

Hi Frank,

=VLOOKUP(A1;Sheet1!$A$1:$B$100;2;FALSE)


I think that you intended:

=VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE)

(semicolons replaced with commas)



Hi Norman,

You got it.

I wrote the formula directly in OE, so I wrote in the Italian way... ;-)

--
Ciao

Franz Verga from Italy