still trying to get excel to return name when a number...

[Johnny Fix]

Hi still trying to get excel to give me a name when a number that falls within a range of numbers on another sheet appears.

Esentially what i have is drivers who use a series of invoices, NOT NECESSARILY IN SEQUENTIAL ORDER - 12 drivers with each ahving 3 to 5 batches of invoices... trying to tie invoice number to driver names wihout going to driver logs, etc...

Ibuilt one sheet labled INVOICE TRACKING, 3 columns, A) lowest invoice # B) highest invoice number C) Name

Would like to be able to input invoicenumber in another sheet and have excel tell me who held that invoice...


Can anyone help?

 

[Scott Huish]

Have a look at the VLOOKUP function.

 

[Aladin Akyurek]

Hi still trying to get excel to give me a name when a number that falls within a range of numbers on another sheet appears.

Esentially what i have is drivers who use a series of invoices, NOT NECESSARILY IN SEQUENTIAL ORDER - 12 drivers with each ahving 3 to 5 batches of invoices... trying to tie invoice number to driver names wihout going to driver logs, etc...

Ibuilt one sheet labled INVOICE TRACKING, 3 columns, A) lowest invoice # B) highest invoice number C) Name

Would like to be able to input invoicenumber in another sheet and have excel tell me who held that invoice...


Can anyone help?

Control+shift+enter, not just enter:

=INDEX('INVOICE TRACKING'!$C$2:$C$100,
   MATCH(1,IF(A2>='INVOICE TRACKING'!$A$2:$A$100,
    IF(A2<='INVOICE TRACKING'!$B$2:$B$100,1)),0))

where A2 houses an invoice number of interest.