Multi Column Lookup
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?
|