Matching items in 2 columns and calculating %

[Captain_Bluebear]

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.

 

[AhoyNC]

Maybe something like this?

Excel Workbook
	A	B	C	D	E
1	Product		Product		Percent
2	Apples	135	Apples	15	11.11%
3	Bananas	70	Cucumbers	10	33.33%
4	Cucumbers	30	Pears	7	46.67%
5	Pears	15	Strawberries	20	8.00%
6	Strawberries	250
7
Sheet

 

[Captain_Bluebear]

Yes, excellent.

Thanks for that. I needed to include the IFERROR at the start as well which is what I wasn't doing.
Cheers AhoyNC

 

[AhoyNC]

You're welcome. Thanks for the feedback.