View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default VLOOKUP Problems

syntax should be
=VLOOKUP(A1,C:C,1,0)

where A1 is the value you are looking for

--
Allllen


"Erika" wrote:

I am trying to create a VLOOKUP - I want the Table Array to search C:C (all
of column c) - I keep getting an error. Am I doing this incorrectly?