 |
 | 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 / Excel / New Users / June 2006vlookup
when I changed the worksheet that vlookup goes to "named range" the vlookup returned #ref, even though in new worksheet I used same named range. 1) Does it have to be same size of range? 2) Can I just copy the new data into the old worksheet 3) Should I use a dynamic named range? Thanks. Where is your original thread. Always best to reply with top posting.  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > when I changed the worksheet that vlookup goes to "named range" the > vlookup returned #ref, even though in new worksheet I used same named [quoted text clipped - 4 lines] > 3) Should I use a dynamic named range? > Thanks. Please post your VLOOKUP formula, and the location and cell addresses of your Named Range. Vaya con Dios, Chuck, CABGx3 > when I changed the worksheet that vlookup goes to "named range" the > vlookup returned #ref, even though in new worksheet I used same named [quoted text clipped - 4 lines] > 3) Should I use a dynamic named range? > Thanks. =VLOOKUP(E167,derek,9,FALSE) derek is named range in next worksheet. I copied new data into the worksheet and it worked. > Please post your VLOOKUP formula, and the location and cell addresses of > your Named Range. [quoted text clipped - 10 lines] > > 3) Should I use a dynamic named range? > > Thanks. If the range name derek doesn't have 9 columns, you can get that error (since you're trying to return the value from the 9th column of that range). > =VLOOKUP(E167,derek,9,FALSE) > derek is named range in next worksheet. I copied new data into the [quoted text clipped - 13 lines] > > > 3) Should I use a dynamic named range? > > > Thanks. SignatureDave Peterson Glad you got it working......yeah, sometimes VLOOKUP's run into a problem between numerical and text formats, which may have been your case......."it looks like a number but is really text" and VLOOKup won't see it........ Vaya con Dios, Chuck, CABGx3 > =VLOOKUP(E167,derek,9,FALSE) > derek is named range in next worksheet. I copied new data into the [quoted text clipped - 13 lines] > > > 3) Should I use a dynamic named range? > > > Thanks. |
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.