Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel query and link named range | Links and Linking in Excel | |||
How Do I Query a Named Range | Excel Worksheet Functions | |||
sum of a named range with values based on vlookup results | Excel Worksheet Functions | |||
prevent duplicate results (database query) | Excel Programming | |||
help in showing results of database query | Excel Programming |