Nov 04 2021 06:29 PM
answer your question:
In the R3 cell i wish to make a formula that matches whatever row the number in S3 came form. For example, the value in S3 comes from the row that says Carlton Lucas. I wish for R3 to read Carlton Lucas
Nov 05 2021 12:18 AM
@HelpMeExcelinPlease
https://techcommunity.microsoft.com/t5/excel/help-with-formula/m-p/2929593