Lookup a table

C

Cheryl

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
 
F

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


Cheryl said:
I have a text file which does not have a fixed row format and I would
Click to expand...
like to link it to a Excel report
 
C

Cheryl

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
 
C

Cheryl

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

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


Cheryl said:
Please ignore the last 2 mail. Tried to post data but have difficulties.
Click to expand...
How can I attach a simple file?
 
Top