Hi,
I am sure what I'm trying to do is really straightforward but I can't get my brain to take that one extra leap!
Assuming I have a table that looks like this:
HeaderA HeaderB HeaderC HeaderD HeaderE Val1 Val1 Val1 Val2 Val4 Val2 Val3 Val2 Val3 Val5 Val3 Val5 Val3 Val4 Val6 Val4 Val4 Val6 Val5 Val7
Let's say I need a formula that does the following, in order:
Checks to see if a separate value (let's call it Alpha) has a match in the top row to find a header value (i.e. HeaderB). This will be used to provide the column number for a second match.
Checks to see if another separate value (Beta) can be found in that column. This just needs to return a "Yes, there is a match" or "No, this value is not found".
Example - if Alpha = C and Beta = Val2, it will return "Yes, there is a match". (Formula will look up to find C, then look down that column to find Val2)
Example - if Alpha = E and Beta = Val 1, it will return "No, there is no match". (Formula will look up to find E, then will not find Val1).
I've experimented with Index and Match, but I'm not used to doing what is effectively two separate matches in the same formula.
Very grateful for any help someone could offer!
Bookmarks