I am trying to create a lookup function for a data set on Sheet 2 in my
workbook. The lookup function looks like this:

=lookup(b3,Sheet2!$A$2:$A$953,Sheet2!$B$2:$B$953)

All I am getting is a #N/A error message. What am I doing wrong? I have
even used the function button to use the "assistant" fill-ins (something I
rebel against) ... when I trace the error and check the comment, it tells me
there is no data in the cells, which is certainly not true.

Help!