VLOOLUP for different rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet from a supplier with a very large number of products. We only use a small number of their products, so I have made a pricebook that uses the VLOOKUP function to match part numbers, and put description, buy and sell prices from the supplier's sheet in my pricebook
Now they have started putting a more detailed description in the cell below the cell with the short description

e
Cell A1: Part Numbe
Cell B1: Short Descriptio
Cell A2: Blan
Cell B2: Detailed descriptio

Is there a way I can put the detailed description in my pricebook instead of the short description
 
Always 2 lines per part number???

=index(sheet2!b:b,match(a1,sheet2!a:a,0)+1)

Find the match in column A and come down one row in column B.
 
Back
Top