I have an extract that contains one or more rows for a given ID and on a separate sheet I need to modify the VLOOKUP formulae to only pick up the first occurrence for each ID. On the next row I then need the first occurrence of the next ID and so on. I have played about with this formulae to ensure that subsequent VLOOKUPs start at the row below the last selected row, but this only picks up the next occurrence of the same ID.
=VLOOKUP(Sheet2!$D$2,INDIRECT("JLSExtract!A"&P2&":Q"&Q2),2,FALSE)
I use ROW() to return the last selected row in cell P2 and the bottom row in cell Q2
In effect I need to remove duplicates from the extract but the reason fro the VLOOKUP formula is that the selection is dependant upon data in the second column.
Hope someone can help
Bookmarks