Forum Discussion
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 t...
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
- nice gesture.. kudos!
