Lookup a table

[Guest]

I have a text file which does not have a fixed row format and I would like to link it to a Excel report

Eg. Line 5 of the Excel report is linked to line 5 of text file (Product A) in Day 1
When I download day 2 of the report Product A appears in line 4 in the text file
But my formula in Excel file is linked to line 5 of the text file.
Currently what I did was to add a row into the text file in order for the linkage to work
THank you

 

[Fred Smith]

Try using the Match function to determine the row number. If you need more
help, post an example of the data involved.

--
Regards,
Fred
Please reply to newsgroup, not e-mail

I have a text file which does not have a fixed row format and I would

like to link it to a Excel report

 

[Guest]

Enclosed the simple file to further elaborate the problem
Thank you

 

[Guest]

Text File Excel File

P1 P2 P1 P2
L1 AM 100 200 L1 AM 100 200
L1 PM 150 250 L2150 250
L1 EM 300 500 EM 300 500

L2 AM 150 200 L2 AM 150 200
PM 300 250 PM 300 250
EM 200 300 EM 200 300

 

[Guest]

Please ignore the last 2 mail. Tried to post data but have difficulties. How can I attach a simple file?

 

[Fred Smith]

You can't attach files. Most people won't open them anyways for fear of
viruses.

Just explain what you need to do in a text message.

--
Regards,
Fred
Please reply to newsgroup, not e-mail

Please ignore the last 2 mail. Tried to post data but have difficulties.

How can I attach a simple file?