View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chuck buchanan chuck buchanan is offline
external usenet poster
 
Posts: 4
Default Query database results in a named range

Good day.

Worksheet "A" has a working VLOOKUP to a named range in worksheet "B".
However, after adding a query of an MS SQL database to retrieve fresh data,
that VLOOKUP returns "#N/A".

I have placed the query results in another range on worksheet "B" and jumped
through all sorts of hoops to "place" that data in the previosuly named
range, but cannot get past the "#N/A".

Any suggestions are greatly appreciated. Thank you.
--
Chuck Buchanan
Special Projects Coordinator