How to Reverse VLOOKUP | Inverse Search | INDEX MATCH | Google Sheet
#GoogleSheet, #VLOOKUP, #ReverseVLOOKUP, #INDEXMATCH
This video apply the concept of searching a key from data range.
When the value column is present on the right hand side of key column, VLOOKUP can be used.
However, when the value column is present on the left hand side of the key column, VLOOKUP can not provide solution. In this situation, we can apply the combination of INDEX() and MATCH() functions of Google Sheet.
This video answers many common questions such as:
Reverse Vlookup with Examples
How to reverse vlookup function in Google sheet
How to use Reverse VLOOKUP in Google Sheet
How to Perform a Reverse VLOOKUP in Google Sheet
How to do a Reverse VLOOKUP in Google Sheet
How to Perform a Reverse VLOOKUP in Excel
How to do a Reverse VLOOKUP in Excel
How to VLOOKUP in Google Sheet
How to VLOOKUP in Microsoft Excel
Timestamps:
00:00 Introduction and the limitation of VLOOKUP()
01:52 INDEX() function
03:42 MATCH() function
05:13 Combine INDEX() and MATCH()
06:37 Outro