As refer to below images reference.
I am trying to find the value of the quantity value from Sheet 2 if it matches the fruit name to be input inside Sheet 1. Try using LOOKUP but it only return me the value 1 for everything as the name only appear there once.
Example.jpg
Bookmarks