INDEX And MATCH Function
The INDEX MATCH is the combination of two functions in Excel. It looks both the side right and left while Vlookup only lookup in right direction. So its very useful for dynamic lookup reference for the large database. =INDEX() returns the value of a cell in a table based on the column and row number and =MATCH() returns the position of a cell in a row or column.' You can also create a drop down for Product Sku and Model Name / Price