=VLOOKUP(D2,Sheet2!A$2:B$65,2,0)

Did you implement without the "V"?
Note that its VLOOKUP, not LOOKUP <g !
Biff's suggestion works fine for me ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Karen Smith" wrote in message
news:IjGDe.7152$%K2.5273@pd7tw1no...
I am getting the error that I have entered too many arguements for this
function when I use this formula.