Simple Look up

[Guest]

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))

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

 

[Don Guillett]

have a look in the help index for LOOKUP and VLOOKUP

 

[Guest]

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

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Tried it but got same result. Any more ideas? Thank you.

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

I did a test. It is only finding the last value in my array (the bottom row)

 

[Guest]

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

=IF(N13="","",VLOOKUP(N13,'List of class Names'!C,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

 

[Guest]

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