View Single Post
  #5   Report Post  
Karen Smith
 
Posts: n/a
Default

Thanks, I got it working - still don't know what I had typed wrong
previously - had the VLookup.
Help Appreciated

"Max" wrote in message
...
=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.