Dear All,
One way doing is to do multiple vlook up against each column. Just wanted to know if we have another option with straight forward formula to arrive at the value in table 1?
image1.PNG
Tried with below,
Greatly appreciated if anyone knows way around!!Please Login or Register to view this content.
Bookmarks