Compare data in one excel sheet with another excel sheet based on a single column

[suneelkv]

Dear All,

I've one task which i wanna complete in Labview.
I've two excel sheets
Sheet1 - Master table (With 14 cloumns of text in different languages)
Sheet2 - Child Table. (With 14 cloumns of text in different languages)
One unique ID is available in one of the column (in both the sheets) but the ID is available randomly.

Say for ex:
Column B is having the Text ID (TXT_ID1) which is having data like Track Titel Traccia Titre Pista ....... upto 14 languages.

So could you please suggest me some intial model if anybody have worked out on the same.

Waiting for ur responses
Suneel

[smercurio_fc]

I don't quite understand what you're trying to do. Where is this "unique ID"? You said it's in one of the columns in both sheets. What does this mean? You also said "Column B is having the text ID (TXT_ID1)". What does this mean? Is there a cell that contains the text "TXT_ID1"? Can you provide a sample of what your data is, and what kind of lookup you're trying to do?

With respect to code itself, to communicate/control Excel from LabVIEW you will need to use ActiveX. This requires knowledge of the Excel object model, which is documented by Microsoft in MSDN. You can find a number of examples in the Excel thread, so your best bet is to start there. NOTE: Do not post questions into that thread - it's a thread intended to be a repository of links.