vlookup, match, index, inserting rows

[WNMeats]

This is what i want

In put a name _______ input a qty

compare to a list of 216 people

return the name and a qty to a new list

need to keep adding name to the new list
keep an % out of 1000 names compleded and not compleade.

So the lay out would be

Enter name and qty.

Goal is 1000 names before Octuber

% of completion

hide a list of names and qty done

I tryed Trick #540, 539, 1, and isert a roll. could not get it right.

Formulas for Trick 540

N3 getting a number ---- e IS THE NAME WE ENTER

=SUMPRODUCT(--ISNUMBER(MATCH($B$3&$C$3,$E$3:$E$216&$C$3:$C$216,0)


Adding rows to new list

=if(rows(H$3:H3)>$N$3,”try again”,index(B$3,small(IF(isnumber(match($B$3,$E$3:$E$216&$F$3:$F$216,0)),ROW($B$3)-ROW($B$3)+1),ROWS(H$3:H3))))


Option ? *

(isnumber(match($B$3&$C$3

=SUMPRODUCT(--ISNA

1. NUM MATCH N3
2. ENTER NAME AND QTRY b3 c3
3. COMPARE E3 F3
4. NEW LIST H3 I3