Looks like a type-o..........replace the # with $

=Vlookup(A1,$D$1:$E$3,2,false)

Vaya con Dios,
Chuck, CABGx3


"TMF in MN" wrote in message
...
bj,
Thank you for your fast response. I got an error message, am I missing a
set of parenthesees or something?

THANK YOU!

"bj" wrote:

try in B1
=Vlookup(A1,$D$1:#E$3,2,false)
copy down to B3
"TMF in MN" wrote:

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