 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2007Excel 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 Hello, How about a simply IF formula? =IF(A1=B1,"1","0") HTH, JP > 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 We would love to but it would be so much more efficient if you gave a clue what your data looks like. best wishes  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > 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 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? > We would love to but it would be so much more efficient if you gave a clue > what your data looks like. [quoted text clipped - 3 lines] > > one column to data in another and place a 1 in another column to sort by > > later. Thanks Sure does. Try: =if(isna(vlookup(whereverlistof632is,A:A,1,false)),"not there",1) SignatureRegards, Fred > 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. [quoted text clipped - 10 lines] >> > one column to data in another and place a 1 in another column to sort by >> > later. Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.