Parent Item Component Item Qty Req'd Unit of Measure 91013
91013 089783 1 EA Select at least 46 row(s).
91013 089580 1 EA Select at least 46 row(s).
91013 091084 1 EA Select at least 46 row(s).
91013 089566 1 EA Select at least 46 row(s).
91013 090939 1 EA Select at least 46 row(s).
91013 089546 1 EA Select at least 46 row(s).

Maybe one of you who uses Alan Beban's wonderful vlookups formula can
help. I am trying to lookup using value in F1 (91013) to look up all
occurrences of that value in column B. The answers should appear
starting in F2 and downward but instead I get this weird message
"Select at least 46 row(s). What I should be getting is the values
you see in column B should be listed. The formula I am using is
{=vlookups(F$1,$A$2:$B$2517,2)}. I have copied the vlookups VBA module
into the spreadsheet I am doing this in and this is what I get. Anyone
see what's wrong?

Thanks!


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=319904