Reverse Lookup-Lookup Data Using Index and Match Function
In this video, we'll use MATCH to find the position of sales value that given in a table, and the INDEX function to retrieve the value at that position in a two-way lookup.
For more details watch this video till the end