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

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

lookup value and print all instances
 

you could use datafilterautofilterfilter on b and then print

--
Don Guillett
SalesAid Software

"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

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

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