How to do index match based on two columns
I have two sheets. One that has just first name and last and the other which I will call the source file that has first name, last, phone numbers and a lot of other things. I am trying to see if there is a formula in which I can use Index Match to check both the First Name and Last Name to return the phone number from the source file.
Help Article Resources
Check out the Formula Handbook template!