I tried both and I get N/A as a result even though I see the match
=VLOOKUP(B2,'Lookup 2'!B:B,1,False)
=VLOOKUP(B2,'Lookup 2'!B:B,1,0)

"Allllen" wrote:

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?