Thread: Skip blank columns with LOOKUP formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Skip blank columns with LOOKUP formula
1 way to use the function:

=INDIRECT("Schedules!"&kol("B"&MATCH(A1,Schedules! A1:A100,0))&MATCH(A1,Schedules!A1:A100,0))


Reply With QuoteReply With Quote