I have a list of customers sites where each site has a unique number.

Against each of the numbers is the name of the site for example;

001 London
002 Oxford
..
..
1340 Birmingham
1341 Manchester
etc. etc.

These are listed in 2 columns on a hidden worksheet in a multi-page
spreadsheet.

What I would like to do is when the site number is input say in cell A1 on a
different worksheet I need to automagically insert the site name that
matches that particular site number.

So in my example if I input 002 in cell A1 then Oxford appears in B1

I am guessing I need to use VLOOKUP or something but can some kind soul
point me in the right direction please?


--
Thanks & regards,
-pp-