I have a sheet with accounting data from MS SQL Server.

Fields include BudgetID, Period, and the account numbers in three seperate
fields ActNumbr_1, ActNumbr_2, and ActNumbr_3.

I need a lookup like this on the multiple columns:

BudgetID contains "FY04"
Period = 2
ActNumber_1 = "100"
ActNumber_2 = "3000"
ActNumber_3 = "01"

Any suggestions on how I can do this?

"Claude Hebert Jr" wrote in message ...
I have a sheet with accounting data from MS SQL Server.

Fields include BudgetID, Period, and the account numbers in three seperate
fields ActNumbr_1, ActNumbr_2, and ActNumbr_3.

I need a lookup like this on the multiple columns:

BudgetID contains "FY04"
Period = 2
ActNumber_1 = "100"
ActNumber_2 = "3000"
ActNumber_3 = "01"

Any suggestions on how I can do this?

You can use an SQL query to pull that specific data from the server, can't you?

I have tried getting the sql.request function to work but have not had
any luck with it. No matter what I have tried, I get a #N/A error.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

"Claude Hebert Jr" wrote in message ...
I have a sheet with accounting data from MS SQL Server.

I need a lookup like this on the multiple columns:

BudgetID contains "FY04"
Period = 2
ActNumber_1 = "100"
ActNumber_2 = "3000"
ActNumber_3 = "01"


What method is being used to populate the sheet with data?

--

The sheet is being populated with a sql query created in excel.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Claude Hebert Jr wrote in message ...

The sheet is being populated with a sql query created in excel.

Maybe this is what you need (link to Excel MVP Dick Kusleika's site):

http://www.dicks-clicks.com/excel/Ex...htm#Parameters

--

Suppose ur data is contained in columns A1 to A5.
Put in column A6:=A1&A2&A3&A4&A5&A6.
This will give you a unique combination of all the columns.
U may then run vlookup on this column


---
Message posted from http://www.ExcelForum.com/

that was the first thing i tried. wheb the query is refreshed the formula
references get screwed up

"anurag.d " wrote in message
...
Suppose ur data is contained in columns A1 to A5.
Put in column A6:=A1&A2&A3&A4&A5&A6.
This will give you a unique combination of all the columns.
U may then run vlookup on this column


---
Message posted from http://www.ExcelForum.com/