Expanded Vlookup Issue

There's a UDF called VLOOKUPS that does what you want. I installed it into your sheet and activated it in the range.

http://home.pacbell.net/beban/

The code for the functions are called:

VLookups
ArrayCountIf
ArrayDimensions
MakeArray

They are copied into a standard module. Then you enter a standard VLOOKUP type formula:

=VLOOKUPS($H$4,$B$4:$E$17,2)

When you press Enter, a message will appear in the cell telling you how many
cells downward you need to select.

Highlight the cell and drag down enough cells below to complete the requested number (or more if you want expansion room), press F2, then CTRL-SHIFT-ENTER to activate the array.