i have three worksheets 'Front', 'CPC' and 'Declaration'.
In 'CPC' i have a list of codes in columnA then columns B, C, D, and E have
values (%) which are applicable according to the codes. each code in
worksheet 'CPC' have there values. for example:

columnA | B | C | D | E |
row1: C400 | 5% | 10% | 1.5% | 3% |
row2: C418 | 10% | 5% | 2% | 8% |

On worksheet 'Front' G27 contains the cpc codes. i need the cells J31, J32,
J33 and J34 to be linked to the columns on 'CPC' columnB C D E respectively.
so if G27 on 'Front' is C400 then J31=5%, J32=10%, J33=1.5% and J34=3%

if G27 is C418 J31 should now be 10%, J32=5%, J33=2% and J34=8%

i'm not sure how to do this.. but i assume in each of these cells (J31 J32
J33 J34) should have there individual formula to pick up the values depending
on which row the codes is in on worksheet 'CPC'.

i hope someone understands me. let me know if i gave enough info.
thanks in advance.

--
help a friend help you