Look up data based upon the intersection of 2 cells with specified contents

[mrrcx1]

Hey,
I have a set of data with the type of data in certain rows and the output from sensors in the columns. Legacy data isnt always in the same orientation and I want to code in a macro to search for the intersection of a row and column, copy that cell into elsewhere on the page and organize it to be pulled and plotted from.
The names within the cells to be used for lookup will not change, but the location of the intersection will.

 

[Marc L]

Hey,​

​

again a guessing challenge ?‼ As you was already warned on another forum to be more explicit …​

 

[mrrcx1]

Hey Marc, Thanks for the reply. That helps. Looks like my post got cut off. Since you saw my post with more information in another forum do you have anything helpful to offer?

 

[mrrcx1]

To anyone else looking into this topic, this looks like a solution.

How to use two-way lookup formula in Excel?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Please provide links to any/all forums where you have posted this question.

If you cross-post in the future and also provide links in your initial post, then there shouldn’t be a problem.