=VLOOKUP('Sheet2'!A1,'Sheet1'!A1:B200,2,0)

--

Regards,

Peo Sjoblom

"George" wrote in message
...
pls advise how to solve the following,

city names are 3 letter coded

sheet1
A B
1 CPH Copengagen
2 FRA Frankfurt
3 BCN Barcelona
4 DUB Dublin

I have extracted from database many 3letter coded city names
but i need also full name next to it. what would be the formula?

sheet2
A B
1 CPH ?formula?
2 CPH
3 DUB
4 FRA
5 FRA
6 BCN
7 CPH

thank you very much in advance!