SOLVED

Help With Formula

New Contributor

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 Replies

@HelpMeExcelinPlease Made some changes in the first part of columns Q:S. See if that does what you need. You used a mix of MAXIF, LARGE and VLOOKUP. The attached file uses INDEX/MATCH and LARGE.

best response confirmed by HelpMeExcelinPlease (New Contributor)
Solution

@Riny_van_Eekelen 

 

Yes thats perfect. I think I can figure everything out from here! Thanks so much!