A B C D E
1 1 x 1 Oranges
2 1 x 2 Apples
3 2 x 3 Grapes

If A1 matches any cell in D1 - D3, enter value in the matching E column into
B1.
Something like ... if A1= D1:D3, then E1:E3.. but I can't get it to work.

THANK YOU SO MUCH!!
TF