=VLOOKUP(99,C:D,2) works from the top of column C to the bottom. Here we
look for 99 in column C and return the adjacent value from column D
--
Gary''s Student - gsnu200759


"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?