Multi Column Lookup

  • Thread starter Claude Hebert Jr
  • Start date
C

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?
 
B

BOHICA

Claude Hebert Jr said:
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?
Click to expand...

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

onedaywhen

Claude Hebert Jr said:
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"
Click to expand...

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

--
 
C

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.

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

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
 
C

Claude Hebert Jr

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