Forum Discussion
How to use vlookup with unique identifier used multiple times on spreadsheet.
I'm comparing two reports with the SSN as the unique identifier, but I'm only getting 1 line of data. I need to pull multiple lines of different data for that one SSN. Hope this makes sense. --thx
=IFERROR(INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$E$2,ROW($A$2:$A$9)-1),ROW(A1))),"")
You can try this formula because VLOOKUP isn't the right formula if i correctly understand what you want to do. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The formula is in cell F2 and filled down.