I have got a spreadsheet that I need help with a vlookup formula. In Column A it has a Notice Number. In Column E, it has cell(s) of data for each Notice Number. If it was the case, there was one cell of data for each notice number, I can use the following formula in Column G:
=vlookup($A1,$A$1:$K$1000,5,False) and it would work fine. The problem is there is multiple (1 - 15) amounts of data for each notice number. The data is listed below each other. Example Below:
Column A Column E
Notice Number Data
Notice Number 1 Data 1
Notice Number 2 Data 2
Data 3
Data 4
Notice Number 3 Data 5
Notice Number 4 Data 6
Data 7
What formula can I use to pull of the data items in Column E for a particular Notice Number in Column A?
=vlookup($A1,$A$1:$K$1000,5,False) and it would work fine. The problem is there is multiple (1 - 15) amounts of data for each notice number. The data is listed below each other. Example Below:
Column A Column E
Notice Number Data
Notice Number 1 Data 1
Notice Number 2 Data 2
Data 3
Data 4
Notice Number 3 Data 5
Notice Number 4 Data 6
Data 7
What formula can I use to pull of the data items in Column E for a particular Notice Number in Column A?