hi guys
I would match column B across multiple sheets with helper column K into sheet FS ,if the missed item in column B matched with one of them into column K , then should repeat for all the items across multiple sheets . for instance the sheet FS one item contain INDO ,then should fill all of item INDO in last position ,also sheet DTYO there are about four items into column B contain THI , then should fill all of the items THI .as to sheet FSI there are about three items into column B contain JAP, then should fill all of the items JAP .
but I have rare case , somtimes there is no items into column B match with column K . I mean to don't contain any items based on column K, then should fill all of the items JAP
I put the result how should be as in last three sheets, but should be in the same sheet for each sheet separately
also issued in this forum https://www.mrexcel.com/board/thread...olumn.1198169/
Bookmarks