Vlookups
 

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

Sorry I always forget how the columns get messed up when you actually
post the message. It now looks like my columns don't match the
formulas but they really do. Just change every reference to column
"F" to column "E" and it will make sense. Thanks.


--
wmjenner


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

wmjenner wrote:
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!


I assume that by "vlookups VBA module" you mean the entire module from
the file downloaded from http://home.pacbell.net/beban. It looks to me
as if when you are array entering the formula you are selecting a single
cell (or some other number of cells less than 46), but that you have 46
occurrences of 91013 in Column A; if that's so, then select at least 46
cells instead (a la the "weird" message). You need to select enough
cells to accommodate the output. Post back if this doesn't solve the
problem.

Alan Beban