| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adjacent to a specific sentence
COLUMN A A1:Revenue A2:Revenue Per Share A3:Qtrly Revenue Growth A4:Gross Profit A5:EBITDA A6:Net Income Avl to Common A7:Diluted EPS A8:Qtrly Earnings Growth COLUMN B B1:9.15B B2:2.062 B3::12.30% B4::4.12B B5::1.51B B6:907.00M B7:0.19 B8:N/A say i want the result adjacent to the sentence "Qtrly Revenue Growth" which is 12.30% what formual do i have to use that includes All cells A1:A8 thank you -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=509510 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adjacent to a specific sentence
.......... -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=509510 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
adjacent to a specific sentence
If I understood you correctly, try:
=VLOOKUP(A11,A1:B8,2,FALSE) -- Kevin Vaughn "Pivotrend" wrote: COLUMN A A1:Revenue A2:Revenue Per Share A3:Qtrly Revenue Growth A4:Gross Profit A5:EBITDA A6:Net Income Avl to Common A7:Diluted EPS A8:Qtrly Earnings Growth COLUMN B B1:9.15B B2:2.062 B3::12.30% B4::4.12B B5::1.51B B6:907.00M B7:0.19 B8:N/A say i want the result adjacent to the sentence "Qtrly Revenue Growth" which is 12.30% what formual do i have to use that includes All cells A1:A8 thank you -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=509510 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
| Entering data and spanning adjacent cells | Excel Discussion (Misc queries) | |||
| Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
| How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
