Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect
Since =match() returns the number of the row that matched, how about just
subtracting 1? =INDEX('August Inventory Transactions '!C:C, MATCH(C119,'August Inventory Transactions '!A:A,0)-1) ps. I'd get rid of that trailing space at the end of the worksheet name. It looks like it's just a problem waiting to happen (to me, anyway). Todd wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define chart range using indirect reference | Charts and Charting in Excel | |||
2 different INDIRECT data validation lists from one | Excel Discussion (Misc queries) | |||
Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |