Forum Discussion
Excel Formula
Good day to all! Please help me on my project. I want to create an excel formula that comes out on this situation below: Column A & B is a given data. Then Column E is the value/text which...
I'm so sorry, I will make it simple. CSSUmueje
Column A & B are the given data.
Column E and F are the text that needs to find on Column A and B. I want to automatic find the subclass base on its class. (PACKAGE GEOMETRY, REF DES, BOARD GEOMETRY)
Column G will show the results if the text if found or not.
Kindly see the file. If not yet clear just let me know. Thank you!
See the attached workbook for multiple formulas (that locate a Class's range, look for a match within the range, offer hyperlinks to get to a Class/Subclass). Be sure to read the _Info worksheet.