Try something like this:

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

HTH,
Paul

"Todd" wrote in message
...
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