Ok, that worked fine for column B. Unfortunately, it's not going to work for
the next three columns (C,D, and E). Not sure how to change the formula for
each column.

"Barb Reinhardt" wrote:

Why not use

=VLOOKUP(A5,'[Sortable Complete Records.xls]Sheet1'!$A$4:$B$1000,2,false)

You'll know when you don't have a match.

"DJ" wrote in message
...
My problem is that my formula is returning values for which there
shouldn't
be a value. Here's the first formula...

=LOOKUP(A4,'[Sortable Complete Records.xls]Sheet1'!$A$4:$A$1000,'[Sortable
Complete Records.xls]Sheet1'!$B$4:$B$1000)

It returns the proper result.

The next line has this formula...

=LOOKUP(A5,'[Sortable Complete Records.xls]Sheet1'!$A$4:$A$1000,'[Sortable
Complete Records.xls]Sheet1'!$B$4:$B$1000)

There is no match for "A5" in the other spreadsheet, so I'd like it to
ruturn either a "0" or nothing. Instead, it returns the same results as
the
previous line.

Thanks in advance for any help.