Sumproduct or VlookUp

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula to display cell address 2
IF STMNTWITH SUMPRODUCT ARRAY 2
alternative formula for VLOOKUP since it stops with the 1st value itself 2
transpose multiple rows into one column 2
VLOOKUP won't generate correct response for "inbetween" values 9
Vlookup to look up multiple fields? 5
VLookup only calling one cell 3
IF and VLOOKUP 2

Top