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 Smith' location in A:A will vary from day to day. (i.e The number I would need it to give me is in K:9 but tomorrow it could be in K:14)
Having a hard time coming up with the right formula.
1 Reply
Maybe you can try to use the VLOOKUP function in Excel to achieve this.
=VLOOKUP("John Smith", LOA!A:K, 11, FALSE)
