V
Venice
Hi I have the following scenerio. Not sure what should I use Sumproduct or
Vlookup. Appreciate if your help.
Product Thailand Japan China
A 30 40 50
B 35 45 65
C 60 70 80
If I need to create a cell (say in A20) to have a result of China with
product C (answer shld be 80). What formula should I choose? Many Thanks
Vlookup. Appreciate if your help.
Product Thailand Japan China
A 30 40 50
B 35 45 65
C 60 70 80
If I need to create a cell (say in A20) to have a result of China with
product C (answer shld be 80). What formula should I choose? Many Thanks