My vlookup range starts based on a unique "Text" occur once in a cell in B:B
and end when the same occur once in a cell in A:A
Within this target range of rows there are unique texts like text-1,text-2,
text-3€¦ and so on belongs to the "Text" and they are in A:A but unevenly
spaced.
I need vlookup values located in row of col C:C. Below is example.

"Text"
Text1 50

Text2 60
Text3 45

Text4 50

Text5 20

Text6 80
"Text"
Thanks for any help to resolve this