up vote 1 down vote favorite
share [g+] share [fb]

I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open Office or Microsoft Excel?

link|improve this question
Whats your operating system? – wizlog Aug 29 '11 at 15:55
@wizlog what does it matter? Google Spreadsheets is an online app, Open Office is cross platform, and you know what OS Excel runs on. – Breakthrough Aug 31 '11 at 14:17
@Scott I'm not sure about any utilities other than Excel, but if you do go with Excel, you'll need to write a custom VBA function to import the CSV file and go through it to find the matches. This cannot be done without VBA (in Excel). – Breakthrough Aug 31 '11 at 14:18
Sounds like a job for vlookup. Any chance you could post some sample data? – F106dart Sep 1 '11 at 12:34
@Breakthrough - It's a reasonable question, since Excel also runs on Mac, and the 2008 version lacks VBA support. – Joe Internet Sep 1 '11 at 12:42
show 1 more comment
feedback

closed as not a real question by Diago Oct 30 '11 at 12:13

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. See the FAQ for guidance on how to improve it.