adjacent to a specific sentence

[Pivotrend]

COLUMN A
A1:Revenue
A2:Revenue Per Share
A3:Qtrly Revenue Growth
A4:Gross Profit
A5:EBITDA
A6:Net Income Avl to Common
A7iluted 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]

..........

 

[Kevin Vaughn]

If I understood you correctly, try:

=VLOOKUP(A11,A1:B8,2,FALSE)