Vlookup with multiple option

[ceclay]

I have this list in Data A wherein Column B has varying values. What I would like to do is use Vlookup in Data B if possible where in its value is those fruits with prices.

Data A

Fruit	Price
Lemons	150​
Bananas	250​
Bananas	n
Apples	350​
Oranges	550​
Oranges	n
Lemons	n
Apples	n
Oranges	n
Apricots	650​

Data B

Lemons
Bananas
Apples
Oranges
Apricots

 

[DanteAmor]

Try this:

Dante Amor.xlsm
	A	B	C	D	E
1	Data A			Data B
2	Fruit	Price		Lemons	150
3	Lemons	150		Bananas	250
4	Bananas	250		Apples	350
5	Bananas	n		Oranges	550
6	Apples	350		Apricots	650
7	Oranges	550
8	Oranges	n
9	Lemons	n
10	Apples	n
11	Oranges	n
12	Apricots	650
Hoja3

Cell Formulas
Range	Formula
E2:E6	E2	=LOOKUP(2,1/((A3:A12=D2)*(ISNUMBER(B3:B12))),B3:B12)

 

[ceclay]

Thank you @DanteAmor

 

[DanteAmor]

Im glad to help you. Thanks for the feedback.