Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of names (upper and lower case letters) A2:A26 formatted as txt
in worksheet named 'Txt'. In columns B:I I have the following headings in the first row:- Horse Runs Wins Second Third Winmoney Totalmoney CD I wish to match the txt data in column A (shorter list up to A26) against column B (longer list up to B1501). All data in column A is in column B. All data in column B is in upper case. After matching, I would like column A data along with the corresponding data in columns C:I dumped in another part of the worksheet, say K2. Is this possible? The data could then be copied to another worksheet. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
Concatenate and Vlookup | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
Can you use Concatenate with the If function with vlookup in the i | Excel Worksheet Functions |