Vlookup Partial Match and SUM match

[boobeebee]

Dear senior, i have attached the exercise here. let's say for all pen either name as " pen " or " pens " can return the total units. what is the correct vlookup i should do. appreciate your reply. thank you in advance.

[zbor]

Here, try this:

Please Login or Register  to view this content.

[boobeebee]

its working, thank you so much