Vlookup based on a unique "Text" occur

N

Narnimar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top