Thread: Complex Lookup
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Complex Lookup

Another play to try ...

Assuming source table in cols A to C*, data from row2 down
*ie Pool, Part #, Final Discrepancies

Put in D2:
=IF(C2="","",COUNTIF(C$2:C2,C2))

Put in E2, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(D2="","",IF(ISNUMBER(MATCH(-C2&"_"&D2&"_"&B2,C$2:C2&"_"&D$2:D2&"_"&B$2:B2,0)), "Move
"&C2&" to
"&INDEX(A$2:A2,MATCH(-C2&"_"&D2&"_"&B2,C$2:C2&"_"&D$2:D2&"_"&B$2:B2,0)), ""))

Select D2:E2, fill down as far as required. Hide away col D. Col E should
return the required "action" indications (resembling what you're after)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---