Hi climate,

Not sure this is what you want but try this in N100
=VLOOKUP(M100,$A$1:$B$273,2,FALSE)
and drag it down to N373.

HTH
Martin


"climate" wrote in message
...
Hi
I have 2 columns, column A consist of digit 1 to 273. and column B is name
of city.
That is duplicate. when i copy A1:A273 or cells individualy to M100:M373,i
want to transfer related name in B1:B273 entirly or singular,would you
please
help me?
regards
A B
1 Rome
2 Rome
3 london
4 london
.. ...
273 calif