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 |
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 |