Forum Discussion

Chris Walters's avatar
Chris Walters
Copper Contributor
Sep 20, 2018

Pulling from a third row based on matching criteria from two rows to two other cells.

I want to make a template doc that I can copy info from other reports for a variety of clients into and have it auto fill based on what client I've uploaded. In this case, columns A-C would stay in the template while columns G-J would be copied to the workbook. I would like column K to select the correct "Entry Method" based on the client which utilities they use.

For example, if I upload a report for Client A that has Utility 1, column K would auto fill "I", but if I uploaded Client C that has Utility 1, column K would auto fill "O".

 

excel
Formulas and Functions
  • Chris Walters's avatar
    Chris Walters
    Copper Contributor
    Sep 21, 2018

    Thanks for all the help! You guys have been wonderful. Fortunately I was able to resolve the issue with the INDEX and MATCH functions. Did you know that you can match multiple criteria by simply putting the "&" symbol between the two criteria you are wanting to match and the two arrays you want to match it too?

     

    For the mock sheet provided, it looks something like this =INDEX(C:C,MATCH($H$1&J2,A:A&B:B)).

     

    I hope this helps someone else out there one day :D

Resources