Forum Discussion
Solved
Complicated Excel Lookup Formula
Hi, I'm using the formula below to find people who match the name in cell G407. The "Moraga" worksheet in the Lafayette file has cells with a lot of text, including text that matches the name in ...
mtarler I have 365. I have it almost working now. Sometimes, the formula returns information from the first cell/column ("C") and other times it returns info from the next cell/column ("D"). I just figured out when it does this: if there is not another instance of the G407 term, the formula gives me the number in cell D - it shifts to the right, instead of down. It would be much better if it can give me the result from the only time the name can be found. If you can fix this, I will be grateful. 🙂
IGNORE my other messages.
I'm not sure where to begin because I'm lost. Let me do a better job explaining what data I have available and what I'm trying to accomplish: 1) The complete AOBS worksheet has almost 30,000 addresses with the information that you can see in the sample columns on the AOBS file (owner's names, date purchased, city, etc.); 2) The "#1 Formulas Worksheet" is where I am trying to add more names to our database. On this worksheet, I have a variety of information that I am trying to match to the homeowner's information in the AOBS file. For example, I may have the first and last name of a husband and wife in the formulas worksheet and I want to find homeowner's info in the aobs file that includes some or all of their names. Obviously, the more names that match, the more likely that it's a genuine match. In other cases, I have a student's first and last name and I am trying to match his or her last name with a name or names that show up under homeowner's info. Whenever there's a match, I'm bringing that data to the #1 Formulas worksheet. Ideally, I would prioritize data from a row that also has a city match. This is my goal and I'm open to any way to make it happen. Thoughts?
Also, it really sucks that there isn't a way to trigger clicking on the enter key. When I'm going through the data, that seems to be the one surefire way to trigger the formula and get an output. For example, I may have clicked on manual calculation multiple times with nothing changing. But, if I go to the cell, position the cursor at the end of the formula, and then click enter, it immediately gives me the calculation result.