| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
Try
=IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
Tried it but got same result. Any more ideas? Thank you.
"CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
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 "swarm6" wrote: Tried it but got same result. Any more ideas? Thank you. "CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
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. "CLR" wrote: 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 "swarm6" wrote: Tried it but got same result. Any more ideas? Thank you. "CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
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 "swarm6" wrote: 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. "CLR" wrote: 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 "swarm6" wrote: Tried it but got same result. Any more ideas? Thank you. "CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
I did a test. It is only finding the last value in my array (the bottom row)
"CLR" wrote: 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 "swarm6" wrote: Tried it but got same result. Any more ideas? Thank you. "CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Simple Look up
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 "swarm6" wrote: I did a test. It is only finding the last value in my array (the bottom row) "CLR" wrote: 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 "swarm6" wrote: Tried it but got same result. Any more ideas? Thank you. "CLR" wrote: Try =IF(N13="","",VLOOKUP(N13,'List of class Names'!C:D,2,true)) Vaya con Dios, Chuck, CABGx3 "swarm6" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Formula (I thought) | Excel Worksheet Functions | |||
| Looking to create a simple user form with lookup | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| Simple But Stumped | Excel Discussion (Misc queries) | |||
Hybrid Mode
