((My comments in double parentheses - Homer)) "THE CAT SAW THE MOUSE" An Old Armenian Expression FG - 11 No Date Copyright (C) Frank Gordon Redistribution rights granted for non commercial purposes A thetan

((My comments in double parentheses - Homer)) "THE CAT SAW THE MOUSE" An Old Armenian Expression FG - 11 No Date Copyright (C) Frank Gordon Redistribution rights granted for non commercial purposes A thetan

Sorry, pl dismiss the earlier .. Here's a revised, more robust play .. Illustrated in this sample construct: http://www.savefile.com/files/1003536 Complex Lookup - Inventory Matching.xls Assuming source table in cols A to C*, data from row2 down *ie Pool, Part #, Final Discrepancies In D1: =IF(OR(B2="",C2=""),"",B2&"_"&C2) In E1: =IF(D2="","",COUNTIF(D$2:D2,D2)) In F1, array-entered

I have to following inventory data: Pool Part # Final Discrepancies Actions FG11 286692-001 -1 FG13 286692-001 1 Move 1 to FG11 I need a formula that automatically gives me the comment "Move 1 to FG11" considering 1 as the number of parts to move in order to correct both inventories. Please note that there are hundreds of diferent part #'s under FG11 and FG13

Hi, I think if you sort your data based on the column part # and the column pool you can find it very easy. Thanks, -- Farhad Hodjat "Byron720" wrote: I have to following inventory data: Pool Part # Final Discrepancies Actions FG11 286692-001 -1 FG13 286692-001 1 Move 1 to FG11 I need a formula that automatically gives me the comment "Move 1 to FG11"