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.
Hi, I REALLY appreciate your input, but I don't know sql.
http://e.anyoupin.cn/EData/?s=original_keys_school_first_lastnames
if possible,try this online tools. only need upload data according to the sample data format.
if possible,try this online tools. only need upload data according to the sample data format.