Hi All

I have one worksheet called "Main" which contains instrument details
and recalibration due dates.
Individual instrument details are called up to include location code of
where they are in the country, from a combo box and displayed in 6
cells.

The second worksheet called "Depfind", Containes all the addreses and
Telephone numbers of the relevent location codes, eg ab,cd,123. etc.
Again a combo box is used to bring up the contact details on a location
code typed in the box.

What I am trying to do is instead of typing the location code every
time as there are over 500.
Have the location cell on the main worksheet linked to a cell on the
depfind that will call up and display the contact information each
time. There are about 3000 records in the main worksheet with many
types of insruments at the same location.

I have tryed all sorts, INDEX,VLOOKUP,Etc Cant seem to get anything to
work.Access does this perfectly by using columns from the combo box.

Anyone have any ideas. Thanks in advance
Exelplate