LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup with sheet name MatthijsBonte Excel Worksheet Functions 1 June 27th 05 11:14 AM
Lookup values in multipul sheets and show value in another sheet Kim Excel Worksheet Functions 3 June 17th 05 01:56 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 05:57 PM


All times are GMT +1. The time now is 09:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"