The purpose functions row-intelligent in B5:B10, which suggests the items are in numerous rows but in a single solitary column. INDEX returns a price based upon row and column positions, while VLOOKUP searches for a price in the main column and returns details from the specified column. INDEX + MATCH https://manaplay15825.bloggactif.com/37975593/the-smart-trick-of-윈가라오케-that-nobody-is-discussing