 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / January 2008Vlookup
When doing a v'lookup do the lookup value and the table of array must be the same format? see example below example 000102025 table of array 102025 the zero was converted as text would that affect my results. Look up value table array column index range lookup =Vlookup('fcapdata'!a:A,summer!$A:$GF,12False) why when I copied this formula it still refers me to the previous worksheet that was used and when I tried to edit the link it is giving me an error message. Try posting your question in the Excel newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.excel.work sheet.functions&lang=en&cr=US --- S.Y.M. Wong-A-Ton > When doing a v'lookup do the lookup value and the table of array must be the > same format? see example below [quoted text clipped - 5 lines] > formula it still refers me to the previous worksheet that was used and when I > tried to edit the link it is giving me an error message. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.