Excel Two Way Lookup Problem with Four Solutions

In this video, I will show four solutions in this 2-way lookup problem in Excel. The first recommended solution will be the INDEX() and MATCH(), where I used the MATCH() in both row and column. The second solution is the VLOOKUP() function combined with the MATCH(). Since the I used the VLOOKUP(), HLOOKUP() can also be used which is technically the reverse. HLOOKUP() will also be combined with the MATCH() function. The last and the uncommonly used solution is the OFFSET() and MATCH(). The process of using the OFFSET() and MATCH() is similar with the INDEX() and MATHC() Visit my channel: https://www.youtube.com/c/LinethDelaCruz?sub_confirmation=1 Link to download the sample file: https://www.dropbox.com/s/go8926cnken7non/2-way_lookup_problem_with_4_solutions.xlsx?dl=0 Link on a youtube video for Index Match: https://youtu.be/DNSCe92a1iM Link on a youtube video for Index & Match and Sumproduct: https://youtu.be/wB7uJP40gek Link on a youtube video for Basic Financial Model with Scenario in Excel: https://youtu.be/i7dNbxEQayc Link on a youtube video for Lookup the Next Higher Value using a Formula in Excel: https://youtu.be/Xg0_yeYrIt0 Thanks for your time and I hope you learn something from it. 😊 Help me to reach my target audience by sharing my videos with the right people. 😊 Don’t forget to Subscribe! 😊