 Today we are going to see about VLOOKUP Here I have two tabs, one is inventory and another one is sales By adding just product code I am going to pull up the product detail and the price detail For that I am using VLOOKUP formula VLOOKUP is just vertical lookup By pulling the data from search key Here the search key is product code The range is inventory tab Just by clicking F4 The table range will be constant Index Now we are going to pull the product details It is in the second row Index is 2 And I need an exact match So yeah By just adding the product code Now you can pull up the product detail You are going to pull price data Which again is a product code Range, inventory, table is constant Come on Now the index is 3 Just because we are going to pull the data price It is in the third row Look at the exact match Enter Now just by adding the product code You can pull the product detail As well as the price detail By this way you can use the VLOOKUP formula Thank you