Formula for cross tab data filling

M

moonhkt

Hi All

Excel 2003

How to using formula for data filling as below (Y/N) ?

Sheet A
Product A Product B Product C
System A Y N Y
System B Y Y N



Sheet B
System A Product A
System A Product C
System B Product A
System B Product B

moonhkt
 
Top