I have a sheet named Test with columns
[Category],[SubCategory],[Name], [Is in share?]
that need to be compared(except for the column [Is in share?]) with
the sheet named Share.
Share also has the column [Category], [SubCategory], [Name]
If values in Test's columns [Category],[SubCategory],[Name]
are matched with values in Share's columns [Category], [SubCategory], [Name]
then return true. The value true should be in the column [Is in share?]
I tried to use vlookup but not getting it right.
Sheet Test
[Category] [SubCategory] [Name] [Is in share?]
Food ||| Hard ||| FoodHard1 ||| False
Food ||| Hard ||| FoodHard2 ||| True
Food ||| Soft ||| FoodSoft1 ||| False
Table ||| Wood ||| TableWood1||| True
.
Sheet Share
[Category] [SubCategory] [Name] [Date] [Site]
Food ||| Hard ||| FoodHard23 ||| Jan-02-2003 ||| AB
Food ||| Hard ||| FoodHard2 ||| Jan-02-2003 ||| CA
Food ||| Soft ||| FoodSoft15 ||| Jan-05-2003 ||| KK
Table ||| Wood ||| TableWood1 ||| Jan-05-2003 ||| AB