Hi,
Looking for help on the following.
Sheet 1 column AL contains various messages. Sheet 2 columns A and B contain codes and descriptions.
100 commodity missing
101 description missing
102 commodity incomplete
103 description incomplete
Can the following be done with a single formula? Check if column AL on the first sheet contains any of the codes listed on sheet 2 and display the codes and description just once in column ?
As an example Sheet 1 lists data "100 Jargon 100 Filler 102 Random 103 Stuff". Can this be displayed as "100 commodity missing(Just once even though code 100 appears twice) 102 commodity incomplete 103 description incomplete"?
Bookmarks