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