View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Claude Hebert Jr Claude Hebert Jr is offline
external usenet poster
 
Posts: 4
Default 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?