Hi Max

And from Singapore WOW!
I am from the UK
Thank you so much for your input. I will try your recomendation
tonight.
In the mean time I put =t9 to call up the depot code and tried to work
out how to reference that cells content eg "AB" IN the cell below to
call up the address details below from worksheet depfind.

One thing I did discover, because I think trying so many different
combinations in cell t9 VLOOKUP, FIND etc, etc. I type in =t9 press
enter and it returns =t9 the next cell to it returns the correct value
strange Huh have you ever had that one?

I will keep you posted through the group

Best Regards

Excelplate



Excelplate wrote:
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