Hi

Post some details of how your data is laid out. The solution will probably
be a VLOOKUP formula or one with INDEX and MATCH.

Andy.

"Stuart" wrote in message
...
as mentioned in some of my previous queries i work for an accident
management
company. as part of my job i need to instruct independant engineers to
carry
out inspections. in order to do this i need an excel database kinda thing
where i key in the name of the bodyshop or a postcode and it shows me the
engineers i need to instruct. my question is how do i configure an excel
spreadsheet to do this task i have all the postcodes that each engineer
covers and i know this can be done because our call centre has a similar
file
where they key in a postcode and it says what bodyshop to allocate it to
with
a 1st 2nd 3rd and 4th choice. so if someone can tell me how to do this id
be
most grateful.
--
Stuart