Simple Look up

S

swarm6

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.
 
C

CLR

Try
=IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true))

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

The formula I suggested works fine in my test setup. I suggest you double
check the EXACT spelling of the Sheet Name on both the TAB and the formula
(including spaces)......

Vaya con Dios,
Chuck, CABGx3
 
S

swarm6

Thank you. Actually I didn't type it in. I selected the range with the
mouse. So I guess the spelling can't be wrong.
 
C

CLR

What happens if you change the "TRUE" to "FALSE" in the formula?

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

Make sure the ClassCode column is the same format as N13 and the values are
numbers for numbers or text fot text.......

Vaya con Dios,
Chuck, CABGx3



Vaya con Dios,
Chuck, CABGx3
 
C

CLR

Yeah, probably it's a formatting difference problem between N13 and the
ClassCode column in your array.....see my previous post

Vaya con Dios,
Chuck, CABGx3
 
Top