I think I found the error ... I had originally set the formula like the one
Domenic posted, but I didn't include both columns in my table_array argument.
I put the correct range in and it works fine now.

"Biff" wrote:

Post the *EXACT* formula that gives you a #REF! error.

Biff

"Nolene" wrote in message
...
I'm just entering new data in the field (to test the formula mostly) by
typing in C1.

"Biff" wrote:

get a #REF if I try to change the data in C1

How are you trying to change the data? If you type in a new entry or use
a
drop down it should work. If you are cutting/pasting or drag and drop
then
you'll get a #REF! error.

Try this:

=IF(COUNTIF(Sheet1!A1:A25,INDIRECT("C1")),VLOOKUP( INDIRECT("C1"),Sheet1!A1:B25,2,0),"")

Cut/paste and drag/drop won't affect that formula.

Biff

"Nolene" wrote in message
...
I have a list of names in A1:A25, with corresponding dates in B1:B25 in
worksheet 1. In worksheet 2, I have a cell where I enter a name (C1)
and a
cell where a date will go (D1). I want to enter the name in C1, have it
go
to
the list of names and look for a match. If a match is found, enter the
corresponding date into cell D1, if no match is found, leave it blank.

LOOKUP puts in the next item if no match. I tried VLOOKUP with ISNA
around
it, but get a #REF if I try to change the data in C1