Help WIth a formula

[HelpMeExcelinPlease]

answer your question:

• MacBook Air macOS Monterey 12.0.1
•  Microsoft Excel16.4 for Mac 

• 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

[#2]

@HelpMeExcelinPlease 

https://techcommunity.microsoft.com/t5/excel/help-with-formula/m-p/2929593