Question

This question was asked in Use of Hlookup
Isha Gupta's image

Not able to calculate items sold, as the salesman name is written below item name.

help needed !!