corresponding text and numeric cells
Woops! Should add a blank checker to that,
=IF(M100="","",VLOOKUP(M100,$A$1:$B$273,2,FALSE))
HTH
Martin
"MartinW" wrote in message
...
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
|