Thread: Simple Look up
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
swarm6
 
Posts: n/a
Default Simple Look up

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.