View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
onedaywhen onedaywhen is offline
external usenet poster
 
Posts: 459
Default Multi Column Lookup

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

--