Hi there,

This seems like it should be a simple procedure and maybe I haven't had enough coffee yet this morning, but I can't figure out how to do this for the life of me.

Within a specific defined set of cells in a row of data, I want to search for whichever cell has the number "10" in it. I want then to return the text of whatever cell is immediately to the left of that cell that had the number 10.

Can someone please help me with this?

Thank you in advance.