| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare 2 uneven colums
I have 3 data columns. Column A has 100 data cells, Column C has 25 data
cells, Column D has 25 data columns (related to column C). I would like to compare Column A to C and if there is a match, put Column D value in Column B, otherwise leave it blank. Any help would be great! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare 2 uneven colums
Put in B1:
=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D:D,MATCH(A1,C: C,0))) Copy down to the last row of data in col A -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "MDI Anne" wrote: I have 3 data columns. Column A has 100 data cells, Column C has 25 data cells, Column D has 25 data columns (related to column C). I would like to compare Column A to C and if there is a match, put Column D value in Column B, otherwise leave it blank. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare 2 uneven colums
Perfect!! Thank you!!
"Max" wrote: Put in B1: =IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D:D,MATCH(A1,C: C,0))) Copy down to the last row of data in col A -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:370 Subscribers:68 xdemechanik --- "MDI Anne" wrote: I have 3 data columns. Column A has 100 data cells, Column C has 25 data cells, Column D has 25 data columns (related to column C). I would like to compare Column A to C and if there is a match, put Column D value in Column B, otherwise leave it blank. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| uneven ranges and coding | Excel Discussion (Misc queries) | |||
| Compare Sheets values in two colums | Excel Worksheet Functions | |||
| Font looks uneven in spreadsheet | Excel Discussion (Misc queries) | |||
| lookup with uneven columns | Excel Worksheet Functions | |||
| An uneven time-increment | Charts and Charting in Excel | |||
Linear Mode
