| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
info from other sheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set color of cell based on info on another sheet? | Excel Worksheet Functions | |||
| Pulling info into another sheet | Excel Worksheet Functions | |||
| How to copy/paste info into the protected sheet | Excel Discussion (Misc queries) | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
