Hello All,

I hope you are all safe and well. I have clients with various codes and revenue amounts. I want to lookup the total revenue of multiple codes separated by comma in one cell. Can you please provide me with a formula to do that. Please note that separating the codes to different cells would take a lot of time and effort.

Thanks
Sara