Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or VlookUp
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or VlookUp
Suppose you have the table in range A1:D10 with headers in Row 1 ; try the
below formula =INDEX(A1:D10,MATCH("C",A1:A10,0),MATCH("China",A1 :D1,0)) Change "C" and "China" to cell reference If this post helps click Yes --------------- Jacob Skaria "Venice" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP? SUMPRODUCT? not sure how to do this | Excel Worksheet Functions | |||
sumproduct and vlookup | Excel Worksheet Functions | |||
VLookup VS SumProduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT or VLOOKUP | Excel Worksheet Functions | |||
Sumproduct and Vlookup | Excel Discussion (Misc queries) |