Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup value and print all instances
Hi all If i have a value i want to lookup against anouther table and print out something in the column next to it i would use a vlookup. However in this instance there is a number of matchs for the vlookup and i want to print all the values assosiated with it. EG nme attribute a yyy a xxx a juy b kfh b hrhr c ieue So i want to lookup b. It prints out values kfh and hrhr in two different cells. Any help would be appreciated. Thx -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=492732 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup value and print all instances
Will the multiple values always be adjacent or might they be littered
throughout the column? -- Regards, Tom Ogilvy "kanuvas" wrote in message ... Hi all If i have a value i want to lookup against anouther table and print out something in the column next to it i would use a vlookup. However in this instance there is a number of matchs for the vlookup and i want to print all the values assosiated with it. EG nme attribute a yyy a xxx a juy b kfh b hrhr c ieue So i want to lookup b. It prints out values kfh and hrhr in two different cells. Any help would be appreciated. Thx -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=492732 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup value and print all instances
Firstly to Don. I cannot use filter as i wont be using that workbook directly i will be calling the information from anouther one. Secondly to Tom. The values are always next to the value you want to lookup. In the actual bit of work i am doing they are 5 column across but they will always remain 5 columns accross. -- kanuvas ------------------------------------------------------------------------ kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911 View this thread: http://www.excelforum.com/showthread...hreadid=492732 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup value and print all instances
kanuvas wrote:
Hi all If i have a value i want to lookup against anouther table and print out something in the column next to it i would use a vlookup. However in this instance there is a number of matchs for the vlookup and i want to print all the values assosiated with it. EG nme attribute a yyy a xxx a juy b kfh b hrhr c ieue So i want to lookup b. It prints out values kfh and hrhr in two different cells. Any help would be appreciated. Thx If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook =VLookups("b",a1:b6,2), array entered into a two-cell column Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Lookup to return all instances | Excel Discussion (Misc queries) | |||
Lookup formula to return all instances of match? | Excel Discussion (Misc queries) | |||
Multiple instances of lookup value | Excel Discussion (Misc queries) | |||
Lookup function for a value that has multiple instances | Excel Worksheet Functions | |||
Returning multiple instances of the same lookup value | Excel Worksheet Functions |