| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 "VLOOKUP" function
Can anyone help me with using this feature. I am trying to compare data in
one column to data in another and place a 1 in another column to sort by later. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 "VLOOKUP" function
Hello,
How about a simply IF formula? =IF(A1=B1,"1","0") HTH, JP On Oct 19, 2:30 pm, Leon wrote: Can anyone help me with using this feature. I am trying to compare data in one column to data in another and place a 1 in another column to sort by later. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 "VLOOKUP" function
We would love to but it would be so much more efficient if you gave a clue
what your data looks like. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Leon" wrote in message ... Can anyone help me with using this feature. I am trying to compare data in one column to data in another and place a 1 in another column to sort by later. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 "VLOOKUP" function
In columns A through J we have numerical and text data. Column A basically
assigned a sequential number to each record beginning with 1 through 4230. I have a list of 632 records that I want to identify by the number listed in Column A. When each record is found by VLOOKUP, I want the number 1 placed in separate column in the record to indicate that it matched one of the 632 numbers listed. Does this help? "Bernard Liengme" wrote: We would love to but it would be so much more efficient if you gave a clue what your data looks like. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Leon" wrote in message ... Can anyone help me with using this feature. I am trying to compare data in one column to data in another and place a 1 in another column to sort by later. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 "VLOOKUP" function
Sure does. Try:
=if(isna(vlookup(whereverlistof632is,A:A,1,false)) ,"not there",1) -- Regards, Fred "Leon" wrote in message ... In columns A through J we have numerical and text data. Column A basically assigned a sequential number to each record beginning with 1 through 4230. I have a list of 632 records that I want to identify by the number listed in Column A. When each record is found by VLOOKUP, I want the number 1 placed in separate column in the record to indicate that it matched one of the 632 numbers listed. Does this help? "Bernard Liengme" wrote: We would love to but it would be so much more efficient if you gave a clue what your data looks like. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Leon" wrote in message ... Can anyone help me with using this feature. I am trying to compare data in one column to data in another and place a 1 in another column to sort by later. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
| Is there an Excel 2003 equivalent to Word's "versions" function? | Excel Discussion (Misc queries) | |||
| Is there a "last saved on date/user" macro/function for Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 - Save As function inserts "Copy of" | Excel Discussion (Misc queries) | |||
| "Insert Function" pop-up in Excel 2003, has anyone figured out ... | Excel Worksheet Functions | |||
Linear Mode
