Multi Column Lookup

[Claude Hebert Jr]

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?

 

[BOHICA]

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?

 

[onedaywhen]

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?

--

 

[Claude Hebert Jr]

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.

 

[Claude Hebert Jr]

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

 

[onedaywhen]

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/ExternalData6.htm#Parameters

--

 

[anurag.d]

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

 

[Claude Hebert Jr]

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