Lookup between two texts

[Unexpc]

Hi guys
How set a range for lookup that changeable and add cells or remove cells in this range...
And show the result just in one cell not a specific column for this, how can i do this?
this is lookup formula : =LOOKUP(2,1/(#REF!<>""),#REF!)
instead of #REF! in this formula, for example the range of formula between two texts Customer A and Customer B

 

[jasonb75]

Maybe something like

=LOOKUP(2,1/INDEX(Range1,MATCH("Customer A",Range2,0)):INDEX(Range1,MATCH("Customer B",Range2,0))<>"")

Without a visual example (XL2BB please, not screen capture or copy and paste) your question is too vague to give an accurate answer.