Forum Discussion
Complicated Excel Lookup Formula
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.
mtarler I'm feeling SUPER guilty about your time, but I'm going to update you a sample spreadsheet so you can see what the Moraga file looks like. I (actually, YOU) have it working pretty well, with one glaring exception. When there is only 1 record in the Moraga file that matches the name, the formula returns a number (from the adjacent cell). That's okay because I then sorted the spreadsheet and changed the formula for all of the numbers from 2 to 1. It returned the correct information for the homeowner, BUT it did not return all of the other information in the adjacent cells. I'm guessing that somehow the second iteration triggers everything else (when it's a 2, not a 1). Is there a way to get the 1 to have the same impact? Just to clarify, if the search term is Poggetto and there isn't another Poggetto in the file, the formula will return 38 because it's in the cell adjacent to the cell that includes Poggetto.
Also, I'm having trouble following your explanation about how to only get standalone versions of the search term, but I will try again when I'm more alert. Thanks so much for all of your help. When we're finally done here, I'd love to send you a thank you gift.