| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match name colums and paste corresponding values
Hello ALL,
This is my first post. I have three colums A C D. In column A I have a list of name in asc order. In colum C I have a list of name and with it i have associated times values in column D. I want to compare the colums A and C and where it matches want to place the value in the column D in column B. I have searched for it but could not find the solution. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match name colums and paste corresponding values
Hi
Try entering in B1 =VLOOKUP(A1,C:D,2,0) and copy down as far as required. or did you mean =IF(A1=C1,D1,"") and copied down -- Regards Roger Govier "sumit" wrote in message oups.com... Hello ALL, This is my first post. I have three colums A C D. In column A I have a list of name in asc order. In colum C I have a list of name and with it i have associated times values in column D. I want to compare the colums A and C and where it matches want to place the value in the column D in column B. I have searched for it but could not find the solution. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting values from 2 colums into 1 on a seperate workbook? | Excel Worksheet Functions | |||
| Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
| excel should cut & paste lists side by side to save paper | Excel Worksheet Functions | |||
| Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
| Paste Special | Excel Worksheet Functions | |||
Hybrid Mode
