Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Vlookup with multiple reference

VLOOKUP("your_criteria",THREED(Sheet1:Sheet40!A1:B 100),2,0)
This formula is not working
finaly I got it #Name? this ans.
pls help us?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Vlookup with multiple reference

Well, THREED is not a native Excel function, so you must ensure that
the add-in which supports this function has been installed.

Hope this helps.

Pete

On Dec 11, 12:09*pm, Yanky wrote:
VLOOKUP("your_criteria",THREED(Sheet1:Sheet40!A1:B 100),2,0)
This formula is not working
finaly I got it #Name? this ans.
pls help us?


Reply
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
Reference - Vlookup Vanessa Simmonds Excel Discussion (Misc queries) 1 October 5th 08 04:30 PM
Vlookup with Multiple like values in the reference column ckemtp Excel Worksheet Functions 3 July 3rd 08 03:34 AM
How do I vlookup multiple rows with same reference? Kathie C Excel Worksheet Functions 2 March 30th 08 07:09 PM
Vlookup reference the row below jtoy Excel Worksheet Functions 5 August 1st 07 08:05 AM
VLOOKUP Reference Help Max Excel Discussion (Misc queries) 4 December 19th 05 08:28 PM


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

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

About Us

"It's about Microsoft Excel"