Lookup from other sheet
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 |
Lookup from other sheet
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 |
Lookup from other sheet
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 |
Lookup from other sheet
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 |
Lookup from other sheet
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 |
Lookup from other sheet
Pivotrend wrote:
didnt work Try A2: =VLOOKUP(A1,Sheet2!$A$1:$B$5,2,FALSE) instead |
Lookup from other sheet
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) |
Lookup from other sheet
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 |
All times are GMT +1. The time now is 11:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com