#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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*) Code:
=VLOOKUP(D4,A3:B43,2) ie. Code_1 = Result_1, Code_2 = Result_2, etc. Is that what you were looking for? Or did I guess wrong?!?! |
#4
|
|||
|
|||
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? |
#5
|
||||
|
||||
Ooops
Sorry - didn't think to add in the Range Lookup
Quote:
Sorry about that! |
#6
|
|||
|
|||
Quote:
Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with a formula | tinkertron | Excel | 11 | 04-16-2009 11:43 PM |
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 |
Stuck on this formula!!!! | CADmanJP | Excel | 2 | 03-10-2006 02:06 AM |