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