[slurpee55]

line by line...click on Go Advanced. Below this box for entering the message you should see a group of additional options.
Do you?

[Tonservices]

Yes, I see a group for additional options.

[slurpee55]

Okay, do you see, in the second box of that group, a button that says Manage attachments?
If you do, click on it.

[Tonservices]

I am a big idiot. My problem is - I'm trying to run this program with Lotus. If I will use internet explore I hope my problems are fixed. I will wait and see. Thanks.

[slurpee55]

Oh, definitely! Yes, the page is designed for HTML browsers.

[Tonservices]

I have finally attached this file. Take a look and give me some advice (Formula). Thanks a million

[slurpee55]

Ok, which item will you have on Sheet 1? The Given number?

[Tonservices]

Which item will you have on Sheet 1? I will be inputing information into sheet 1. I want sheet1 to match sheet 2 and return number and number date into sheet 1. I have an example on sheet 1 row 2.

[slurpee55]

That's what I thought, but you have at the bottom of column B on Sheet1, "Match with Sheet 2 column B," but you also have the same thing, essentially, on column C and column G. Since the numbers in column B are unique, you only need the one item to match up with the data from sheet 2 - so you would not have to enter the data into columns C or G, either.

[Tonservices]

Is it possible to match collumns (B,C,and G) in sheet 1 with Sheet 2?

[slurpee55]

Matching things is easy - but you have to be clear what you are matching...it sounded earlier like y ou wanted to match "Given Number" on sheet2 with "Given Number" on sheet2 and "return number and number date into sheet 1" (date is not unique and the Total need not be so, so that makes sense.)
Are you now asking to pull all the data over? Just cut and paste.
If you want a match made conditional on all 3 of those values being the same, please make that clear.

[slurpee55]

For instance, this will return the "Number" value for column J
=IF(ISNA(INDEX(Sheet2!B:I,MATCH(B2,Sheet2!B:B,0),7)),"MISSING",INDEX(Sheet2 !B:I,MATCH(B2,Sheet2!B:B,0),7))
and it is just based on the value in "Given Number"

[Tonservices]

I want conditional on all 3. When all three are true insert sheet 2 column G & H. Thanks

[slurpee55]

Well, the easiest way is to combine the data and match it. For instance, in Sheet2 in Column A, I wrote
=(B2&D2&G2)
then on Sheet1 in Column A I wrote
=(B2&C2&G2)
Then in Column J of Sheet1 I wrote
=IF(ISNA(INDEX(Sheet2!A:I,MATCH(A2,Sheet2!A:A,0),8)),"MISSING",INDEX(Sheet2 !A:I,MATCH(A2,Sheet2!A:A,0),8))
What this does is compare the combined data in Sheet2 A2 with the combined data in Sheet1 A2.
For the other data, you would use the same formula but change the column number (the "8" in the above case) to a "9" for the Number Date and a "7" for the Total.

[Tonservices]

I have things in column A, D, E, F, H, & I of sheet 1. Can I move it to column L of sheet one? and Column L of sheet 2?