View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
diaare diaare is offline
external usenet poster
 
Posts: 50
Default 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?