Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2009, 08:35 AM
dehann dehann is offline
Novice
Help for formula
 
Join Date: Apr 2009
Posts: 3
dehann is on a distinguished road
Default Help for formula


Hi guys..
I have a problem about formula what can i use.
Can any one help me?
Thanks before...

Data here..
http://h1.ripway.com/mohax/Sample.xls
Attached Files
File Type: xls Sample.xls (16.0 KB, 22 views)
Reply With Quote
  #2  
Old 04-29-2009, 12:51 PM
tinkertron tinkertron is offline
Novice
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default

I review your request and form and still don't know what you are asking for. Please be more detail about what you want. I know there's a user on here by the name of Bird_Fat. He'll be able to firgure this out for you, but as I mention, please be very detail on what you want.

Total, Color, Actions, and so on.
Reply With Quote
  #3  
Old 04-29-2009, 03:02 PM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help for formula Help for formula Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default Your Happy, Helpful, Bird!

First off - thanks for the swollen head Tinkertron!

OK - dehann,

I'm not sure I understand what you are looking to do!!

Are you saying that you want to enter a code number in Cell D4 from your list and have Cell E4 show the information from your result column that relates to the code number?

If so, then you need to use a VLOOKUP function

Code:
=VLOOKUP(*input cell*,*table [as range]*,*column number to find return value*)
So, using your workseet:

Code:
=VLOOKUP(D4,A3:B43,2)
This will look at Cell D4, then find the same value in the Code List, then return the value in the Result List.

ie. Code_1 = Result_1, Code_2 = Result_2, etc.


Is that what you were looking for? Or did I guess wrong?!?!
Reply With Quote
  #4  
Old 05-01-2009, 09:29 AM
dehann dehann is offline
Novice
Help for formula
 
Join Date: Apr 2009
Posts: 3
dehann is on a distinguished road
Default

Thanks Bird_FAT ...
Yes... thats true...
But if I input large values than Code list it's always show bigger result. That's Result_40.
Can I give some error if I input large values than code list?
Eg I input Code_50, it should be have an error.
And can I using "IF" formula for this logical?
Reply With Quote
  #5  
Old 05-01-2009, 10:39 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Help for formula Help for formula Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Red face Ooops

Sorry - didn't think to add in the Range Lookup

Quote:
=VLOOKUP(D4,A3:B43,2,FALSE)
Adding FALSE to the end tells the VLOOKUP function to only except EXACT Matches

Sorry about that!
Reply With Quote
  #6  
Old 05-01-2009, 10:44 AM
dehann dehann is offline
Novice
Help for formula
 
Join Date: Apr 2009
Posts: 3
dehann is on a distinguished road
Default

Quote:
Originally Posted by Bird_FAT View Post
Sorry - didn't think to add in the Range Lookup



Adding FALSE to the end tells the VLOOKUP function to only except EXACT Matches

Sorry about that!
OK
Thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help for formula Need help with a formula tinkertron Excel 11 04-16-2009 11:43 PM
Help for formula Excel Formula Help Shahzad Excel 1 12-07-2008 04:13 AM
formula in excell curlymal Excel 2 02-09-2007 11:34 AM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM
Help for formula Stuck on this formula!!!! CADmanJP Excel 2 03-10-2006 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft