If Formula
 

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.
--
Costill

If Formula
 

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.

--
__________________________________
HTH

Bob

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