View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Satnam Randhawa[_2_] Satnam Randhawa[_2_] is offline
external usenet poster
 
Posts: 6
Default IF and Then in Excel

I am trying to compare two different cells in two different worksheets.

If the value in A1 in sheet1 is in any of the cells in in sheet2, then value
in B1 in sheet1 should be equal to value in C1 in sheet2.