VLookup a column with uneven spacing

[jamescooper]

Hello,

Say I have the below situation and I want to vlookup the points below, with uneven spacing in the same column, how would I do this please?

So I would have

vlookup of GTMALVERN and WOSTERFST (1st)

WOSTERFST and WOSTER SH (2nd)

WOSTER SH and EVESHAM (3rd)

etc...

Thanks.

GT MALVERN
WOSTERFST
WOSTER SH
EVESHAM

<tbody>
</tbody>

 

[LloydFinancials]

Mr. Jamescooper,

I see you have not received any replies.

I don't understand your example. It would help us if you gave specifics of your formula, value to lookup, and column of values where the lookup is being done. Can you provide a scenario?

Thanks.