Forum Discussion
Excel Formula for: If RANGE contains TEXT, paste TEXT from another RANGE
If sheet & range LOA!A:A contains text 'John Smith' I want to return the data that's in the corresponding row to 'John Smith' from the same sheet but range K:K. The reason why I need this is 'John Sm...
Maybe you can try to use the VLOOKUP function in Excel to achieve this.
=VLOOKUP("John Smith", LOA!A:K, 11, FALSE)