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

Here's a couple of ways:

say that C1 holds the sentence to lookup.

=VLOOKUP(C1,A1:B8,2,0)

or

=INDEX(B1:B8,MATCH(C1,A1:A8,0))

HTH
Jean-Guy