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