Captain_Bluebear
New Member
- Joined
- Nov 18, 2015
- Messages
- 14
Hi all,
I was wondering if anyone could assist me with a problem I am having with a formula.
I have “Main Table” with product in Cell A2:A9 and a number in B4:B9
I also have “Lookup Table” (cell range D2:E9). While some of the products appear in Lookup Table from the Main Table, not all of them do
What I am attempting to do is calculate the % from the item in “Lookup Table” if it appears in “Main Table”.
So
Main Table Lookup Table "Desired Result"
Apples 135 Apples 15 11.1%
Bananas 70 Cucumbers 10 33.3%
Cucumbers 30 Pears 7 46.7%
Pears 15 Strawberries 20 8.0%
Strawberries 250
I thought of VLOOKUP as well as MATCH INDEX, but the % calculation at the end is not making it easy for me.
Thanking you in advance.
I was wondering if anyone could assist me with a problem I am having with a formula.
I have “Main Table” with product in Cell A2:A9 and a number in B4:B9
I also have “Lookup Table” (cell range D2:E9). While some of the products appear in Lookup Table from the Main Table, not all of them do
What I am attempting to do is calculate the % from the item in “Lookup Table” if it appears in “Main Table”.
So
Main Table Lookup Table "Desired Result"
Apples 135 Apples 15 11.1%
Bananas 70 Cucumbers 10 33.3%
Cucumbers 30 Pears 7 46.7%
Pears 15 Strawberries 20 8.0%
Strawberries 250
I thought of VLOOKUP as well as MATCH INDEX, but the % calculation at the end is not making it easy for me.
Thanking you in advance.