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

Sample.xls (16.0 KB, 24 views)

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.

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

So, using your workseet:

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?!?!

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?

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