sup pros

i have this info

in sheet AA
A1:MSFT
B1:LU
C1:CSCO
D1:CAT
E1:IBM
F1:ORCL

& in sheet BB
A1:MSFT
A2:LU
A3:CSCO
A4:CAT
A5:IBM
A6:ORCL

&

B1:MICROSOFT
B2:LUCENT
B3:CISCO SYSTEMS
B4:CATERPILLAR
B5:INTERNATIONAL BUISNESS MACHINES
B6:ORACLE

I want Cells Below Symbols in sheet AA to display the name of the
company from sheet BB

what formula do i have to use if they not in the same order & the order
of the symbols change according to some external information ?


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521534

example: in A2 =LOOKUP(A1,Sheet2!$A$1:$B$5)
copy this formula accross the column

Have sheet1 ranges A1,B1,C1,... as drop down menus
if you want


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521534

didnt work


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521534

didnt work


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521534

Didn't work??!!!!!
I put the effort in to explain to you how to do this, and this is what
I get back from you,
Maybe you should put some effort into it, and try and do something for
yourself!!!


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521534

Pivotrend wrote:
didnt work

Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
instead

Paul Lautman wrote:
Pivotrend wrote:
didnt work

Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
instead

Actually make that

A2: =VLOOKUP(A1,Sheet2!$A$1:$B$6,2,FALSE)

thank you Paul Lautman

worked perfectly





Paul Lautman Wrote:
Paul Lautman wrote:
Pivotrend wrote:
didnt work

Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE)
instead

Actually make that

A2: =VLOOKUP(A1,Sheet2!$A$1:$B$6,2,FALSE)


--
Pivotrend
------------------------------------------------------------------------
Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062
View this thread: http://www.excelforum.com/showthread...hreadid=521534