Alternate Vlookup formula

$A$10 is simply the value you would like to match. This formula is copied exactly from the website I linked. In that site, A10 was simply the cell they were comparing.

Using your situation described above, I would designate, say, D1 as your "Variable" cell. Meaning we will search column A for all records that match the value of D1

So, I would then paste into E1 this formula

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$D$1,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$D$1,ROW($A$1:$A$7)),ROW(1:1)),2))

Then I would copy that formula down as far as necessary. As you copy the formula, Excel will change the bit "Row(1:1)" to "Row(2:2)" and so on. Thereby giving you subsequent matches to your D1 value.