Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Upgraded to Excel XP, Excel 97 Vlookup's corrupted | Excel Discussion (Misc queries) | |||
Dynamic Column VlookUps Based on Week Number | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions | |||
Hlookups + Vlookups | Excel Worksheet Functions |