Hello, I'm trying to solve for returning a cell 2 columns to the right of a lookup value. The problem is my lookup value could be anywhere in the sheet. As an example, I'd like to search for the name "John" anywhere in a row/column in a sheet of random data and return the cell 2 columns to the right. I've uploaded a .jpeg for reference.
Thanks!
Lookup.JPG
Bookmarks