I am trying to get a function to look through a list of 200 parts to match
two text strings, then return a value that corresponded to the last entry
made. Example

columns
D E F
Apples 32 35
Pears 21 20
Beans 55 99
Apples 35 19 in cell e5 i would like a function to return 35
(the f col entry
of the last apples entry) and the user then
enters whatever
they need in B say 19
Oranges 21 25
Apples 19 34 the function should return 19 from cell B4

There may be random number of spaces between the xth apple entry and the x+1
entry hence why i need a searching type function. I only need the function
to work for apples, no other text entries need searched from the list.

Does anyone know how I could get this to fly?

Thanks
LD