Hi there,

I'm trying to use a look up for a paying in slip that was issued from a paying in book on a different spreadsheet.

The paying in slip number e.g 505 will be from a paying in book with a range from e.g 500 - 600

In the Paying in book column the ranges are listed next to each other

RStart........REnd.........PB Ref.
500............600...........AB45

So I can't lookup 505 as it won't return.

Can I use VLookup (or any other formula) to identify that slip 505 is in paying in book AB45 and return a value?