https://youtube.com/watch?v=pP-fsrhndS4Use VLOOKUP when you need to find things in a table or a range by row in Microsoft Excel. For example, look up a price of an automotive part by…