Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP(sorta) againts SQL Server table - HELP!
Simplified scenario:
I have column A and column B with multiple rows of variable data in the column A cells (i.e. account numbers). I want to return a value to the cell in column B pulled from a single SQL Server table which depends upon the value in the column A cell (i.e. account names). It's essentially the same as a VLOOKUP against a SQL table rather than an Excel range. VLOOKUP will not work, so I am looking for other solutions. I am using Excel 2007. I am aware of the SQL.REQUEST function as a clumsy but workable solution, but it is not supported in Excel 2007. Anyone up to the challenge? Thanks in advance! :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP(sorta) againts SQL Server table - HELP!
Index/Match overcomes many of the limitations of Vlookup:
http://www.contextures.com/xlFunctions03.html Regards, Ryan--- -- RyGuy "cpa-mcse.net" wrote: Simplified scenario: I have column A and column B with multiple rows of variable data in the column A cells (i.e. account numbers). I want to return a value to the cell in column B pulled from a single SQL Server table which depends upon the value in the column A cell (i.e. account names). It's essentially the same as a VLOOKUP against a SQL table rather than an Excel range. VLOOKUP will not work, so I am looking for other solutions. I am using Excel 2007. I am aware of the SQL.REQUEST function as a clumsy but workable solution, but it is not supported in Excel 2007. Anyone up to the challenge? Thanks in advance! :) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP(sorta) againts SQL Server table - HELP!
Thank you, but that is not able to look at a SQL database table.
"ryguy7272" wrote: Index/Match overcomes many of the limitations of Vlookup: http://www.contextures.com/xlFunctions03.html Regards, Ryan--- -- RyGuy "cpa-mcse.net" wrote: Simplified scenario: I have column A and column B with multiple rows of variable data in the column A cells (i.e. account numbers). I want to return a value to the cell in column B pulled from a single SQL Server table which depends upon the value in the column A cell (i.e. account names). It's essentially the same as a VLOOKUP against a SQL table rather than an Excel range. VLOOKUP will not work, so I am looking for other solutions. I am using Excel 2007. I am aware of the SQL.REQUEST function as a clumsy but workable solution, but it is not supported in Excel 2007. Anyone up to the challenge? Thanks in advance! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Chart Wizard sorta broken. | Charts and Charting in Excel | |||
SQL Server UPDATE Database from Excel Table | Links and Linking in Excel | |||
How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
VLOOKUP from a file on another server | Excel Worksheet Functions |