sup pros

i have this info

in sheet AA
A1:MSFT
A2:LU
A3:CSCO
A4:CAT
A5:IBM
A6: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 Adjacent to 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=521470

One way ..
In sheet: AA
Put in B1: =IF(A1="","",VLOOKUP(A1,BB!A:B,2,0))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pivotrend" wrote in
message ...

sup pros

i have this info

in sheet AA
A1:MSFT
A2:LU
A3:CSCO
A4:CAT
A5:IBM
A6: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 Adjacent to 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=521470

whats with the 2 figures in the end of the formula
2 & 0

?


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

whats with the 2 figures at the end of the formula
2 & 0

?


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

"Pivotrend" wrote:
whats with the 2 figures at the end of the formula
2 & 0

2 = col_index_num, the 3rd param in the VLOOKUP
(i.e. the col to be returned from the table_array, here, it's the 2nd col,
col B in sheet: BB)

0 = FALSE, the 4th param in the VLOOKUP, i.e. to lookup an exact match
(Typing a zero is just a shorter way to express it, instead of writing
FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

thank you max


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

You're welcome !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Pivotrend" wrote
in message ...

thank you max