Forum Discussion
How to: Search a text value in a column then return the corresponding row text value
Hi, I'm wondering if someone can help me figure out the correct excel formula. Essentially I have two columns, one with text names and the other with text locations. I need a formula that will search ...
Hi! Thank you so much for your response! I've attached a sample of what I was describing in the previous post. Can you please show me what the formula would be for if I want it to return the name associated with location England after searching column 2?
