Yet another lookup question
I have two sheets.
on sheet one
Column C = CommCode
Column E = %
on sheet two
Coulmn C = CommCode
Column I = %
I would like the value in column I on sheet two equal the value of Column E
on sheet one when the CommCodes match (Column C of both sheets are equal)
What is the best way to make this happen?
|