If Formula

C

Costill

Can someone help educate me on the following formula:

=IF(INDIRECT(""&ROW()-2&"!$K$2")=0,"",INDIRECT(""&ROW()-2&"!$K$2"))

It is part of a purchase order log we use and the writer of the formula is
no longer with us.
 
B

Bob Phillips

It is looking in cell K2 of another worksheet, the name of that worksheet
being determined by the row number of the formula cell -2. So in H10, it
will look at K2 in sheet named 8, and if it is empty, return an empty cell,
else that value.
 
Top