| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
corresponding text and numeric cells
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
corresponding text and numeric cells
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
corresponding text and numeric cells
Hi Martin
My purpose is,when i copy A1,A5,A22,.... to M100,M105,M122,... , related name in column B (B1,B5,B22,....), transfer too. regards "MartinW" wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
corresponding text and numeric cells
Hi Climate,
Yes that's what that formula does. Did you copy it to N100 and then drag down to N373. Now when you copy from A to M the corresponding B values will show up in N. HTH Martin "climate" wrote in message ... Hi Martin My purpose is,when i copy A1,A5,A22,.... to M100,M105,M122,... , related name in column B (B1,B5,B22,....), transfer too. regards "MartinW" wrote: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
corresponding text and numeric cells
Hi Martin
I copied this formula = if("","",vlookup,......) to N100,and drag down N100 cell to N373, but not work properly.even i cpied that formula to address bar and run it for N100 cell, error occure and highlited on this part of formula("","",vlookup). Thank's "MartinW" wrote: Hi Climate, Yes that's what that formula does. Did you copy it to N100 and then drag down to N373. Now when you copy from A to M the corresponding B values will show up in N. HTH Martin "climate" wrote in message ... Hi Martin My purpose is,when i copy A1,A5,A22,.... to M100,M105,M122,... , related name in column B (B1,B5,B22,....), transfer too. regards "MartinW" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text to numeric | Excel Discussion (Misc queries) | |||
| how to format cells having text and numeric | Excel Worksheet Functions | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Text to Numeric | Excel Worksheet Functions | |||
| Text to Numeric format | Excel Discussion (Misc queries) | |||
Hybrid Mode
