Thread: indirect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Todd Todd is offline
external usenet poster
  
Posts: 177
Default indirect
Hi, how do I get my formula to return the cell above the match?


=INDEX('August Inventory Transactions '!C:C,MATCH(C119,'August Inventory
Transactions '!A:A,0))

Thanks,


Todd
Reply With QuoteReply With Quote