between numbers

[rumkus]

Hi All

My work sheet 1 contains below columns ( ticket log )

Sale person name begin no end number
Person 1 1 100
Person 2 101 200
Person 3 601 700

Sheet 2 contains sales

Ticket no sales person activity
177 ?

What kind of formula can I put on B column to track down sales person
name ?

Thank you in advance.

 

[Bob Phillips]

=INDEX(Sheet1!A1:A4,MATCH(1,(Sheet1!B1:B4<=A11)*(Sheet1!C1:C4>=A11),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[rumkus]

works perfectly.

Thank you very much indeed.


Bob Phillips yazdi: