Array formula
gordo wrote...
....
=IF($P20=1,IF($D20="",MAX('C:\unzipped\cycle\[cycle counts
sep2005.xls]Recounted SKU''s'!$F$2:$F$400*IF('C:\unzipped\cycle\[cycle
counts sep2005.xls]Recounted SKU''s'!$A$2:$A$400=B20,1,0))))
the purpose of the formula above is to bring back the last qty of a sku
that has been counted, however this only works if the last qty is more
than the previous, so for example:
....
If you want the last quantity for a given SKU, you need a lookup of
some sort rather than a MAX call. If your table were sorted in
ascending order by date, SKUs were in column A and units sold in column
F, then it could look something like
=IF($P20=1,IF($D20="",LOOKUP(2,1/('<whatever'!$A$2:$A$400=B20),
'<whatever'!$F$2:$F$400),""),"")
|