Yet another lookup question

D

diaare

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

CLR

Try this in I2 of sheet2, copied down......

=IF(C2=Sheet1!C2,Sheet1!E2,"NoMatch")

Vaya con Dios,
Chuck, CABGx3
 
D

diaare

Thanks for the quick response.

Unfortuantley your suggestion does not work because I did not give you
enough information.

On sheet one I have each CommCode listed once...but on sheet two they are
listed multiple times...so the row numbers do not correlate.

I tried =LOOKUP(C$3:C$667,Summary!C$2:C$68,Summary!E$2:E$68) and it works
for most of the cells, but a few I get the #N/A error.

I think the error is due to the fact that I do not have the CommCodes in
alphabetical order on sheet one.

Is there a way to make this work without changing their order...I am
thinking that I need to use the INDEX or MATCH functions, but I am not sure
exactly how.

Thanks again
Diane
 
Top