Assigning Numbers?

[frus88]

Hi all

I'm new to this forum so sorry if this is a daft question.

I want to assign numbers to a list of customer names in an excel spreadsheet and then when i have a new spreadsheet each month i would like Excel to find and put the assigned numbers next to the customer name.

Is this even possible??

I'm doing this as i want to import the data into Sage Accounts.

I really hope that someone will be able to help.

Thanks

Ally

 

[shg]

Welcome to the board.

See http://www.contextures.com/xlfunctions02.html