ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sumproduct or VlookUp (https://www.excelbanter.com/excel-discussion-misc-queries/235624-sumproduct-vlookup.html)

Venice

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



Jacob Skaria

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




All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com