have a look in the help index for LOOKUP and VLOOKUP

--
Don Guillett
SalesAid Software

"swarm6" wrote in message
...
I am trying to look up the tuition amount for a class code. All of the
reults of my "look up" are returning the same value. Here's what I've
got.
On my "List of class names" sheet Column C is the Class code that I want
looked up, and D is the tuition amount.

=IF(N13="","",LOOKUP(N13,'List of class Names'!C:D))

Any ideas what I'm doing wrong? Thank you.