Help needed!!! Index or vlookup

[Tricker]

Table 1 ID	Country
1	United States
2	United States
3	United States

<colgroup><col><col></colgroup><tbody>
</tbody>

Table 2

ID	Final Region	Sub-region	user
1	Americas	United States	5
2	Americas	canada	3
3	Americas	Latin America	1

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I need to bring in "User" col from table 2 to table 1, when ID matches in both tables but when sub-region in Table 2 is "United States"

<tbody>
</tbody>

PLEASE HELP!

 

[Tricker]

Thank you Andrew. Sorry won't post in two places again.

I followed the formula from the website that you sent. I am not getting accurate number. Can you please take a look at this formula and let me know where my mistake is?

K	L	M	N	O
				15
1--5	1	$100	$100
6--9	6	$200	$100
10--19	10	$300	$100
20--49	20	$400	$100
50--499	50	$500	$100
	correct	$3,100	=5*M6+4*M7+6*M8
	incorrect	$2,800	=SUMPRODUCT(--(O5>L6:L10), --(O5-L6:L10), N6:N10)

<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

Use the Evaluate Formula tool to step through the formula. Then adjust your thresholds in column L so that you get the correct result.

 

[Tricker]

Thanks! It worked.

 

[Tricker]

Hi Andrew,

Need your help again! I have a multiplication formula that are in fractions. First scenario is when I refer a cell where 29*1.26 is and multiply that with 45 give me 1644, but if I multiply 45*37 it gives me 1665. There is a difference of $20. This is driving me crazy. Please help. Thanks a lot.

Scenario 1
=29*1.26
=37*45
=1644

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Scenario 2
=37*45
=1665

 

[Andrew Poulsom]

Well 29*1.26 is 36.54 not 37. If you want 37 use:

=ROUND(29*1.26,0)

 

[Tricker]

Hi Andrew,

I am trying to create a chart diagram where I can show EAT, THROW and SAVE for those shown months for those seven products. Please help!!

Thank you,

EAT	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16	Feb-16	Mar-16	Apr-16
Apple	0	0	0	0	0	0	13	0	0	0	0	0	0	0	0
Banana	0	0	0	0	0	0	5	0	0	0	0	0	0	3	1
Pear	1	0	0	0	0	0	26	0	0	1	0	0	1	0	0
Mango	0	0	0	2	0	0	0	0	0	0	0	0	0	1	0
Plum	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Peach	0	0	2	0	0	0	10	3	0	0	0	0	0	2	0
Pomogranate	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0
THROW
Apple	0	0	0	0	0	0	4	0	0	0	0	0	0	0	0
Banana	19	0	34	0	1	1	11	2	4	18	4	6	4	31	3
Pear	2	1	0	0	0	0	16	0	0	1	0	0	3	1	0
Mango	2	0	0	5	0	2	0	0	0	0	0	23	23	0	1
Plum	0	0	0	0	0	0	2	0	0	0	0	0	0	0	0
Peach	2	2	0	1	1	9	27	17	4	2	1	1	9	153	291
Pomogranate	0	0	0	0	0	0	15	0	0	0	0	0	1	0	0
SAVE
Apple	0	0	0	0	0	0	4	0	0	0	0	0	0	0	0
Banana	0	0	0	0	0	0	2	0	1	2	0	0	0	0	1
Pear	1	0	1	0	0	0	18	0	0	0	0	0	1	0	0
Mango	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Plum	0	0	0	0	0	0	2	0	1	0	0	0	0	0	0
Peach	2	0	2	0	0	0	17	0	1	0	0	1	0	1	2
Pomogranate	0	0	0	0	0	0	6	0	0	0	0	0	0	0	0

<colgroup><col><col span="15"></colgroup><tbody>
</tbody>

 

[Andrew Poulsom]

Just select your data and insert a Column Chart.

 

[Tricker]

Hi Andrew,

I need your help again. There are two tables, one with Number and Fruits

Table 1

Number	Fruits
1234	Apple
1234	Banana
1234	Pear
1234	Pomegranate
1234	Mango
567	Apple
567	Banana
567	Pear

<colgroup><col><col></colgroup><tbody>
</tbody>

Another table has Case, Number and Fruits. On the Fruits cell, I need to bring all the fruits that are linked to Number 1234 in the same cell. Is that doable? They can be separated by comas.

Case	Number	Fruits
3	1234
4	567
5	568
6	345
7	685

<colgroup><col><col><col></colgroup><tbody>
</tbody>