About Us

Tom Ogilvy

done

--
Regards,
Tom Ogilvy

"Mascot" wrote:

Hi Tom,

I must be missing something. if you could can you email me a copy of the
spreadsheet . Also I am using excel 2000. I don't know if
this makes a difference.

Thanks
Mascot

"Tom Ogilvy" wrote:

When I corrected and tested the formula, I put the values in B7, B8 and B9
rather than B6, B7, B8.

--
Regards,
Tom Ogilvy

"Mascot" wrote:

Hi Tom,

Maybe I am puting the formula in the wrong place. I have the data in sheet2
like you said. On the next sheet (sheet3) I put May06 (5/1/06) in B6, M101 in
B7, 1001 in B8. I then put the formula in C7, but I am not getting the
anything except VALUE#. What am I doing wrong?

Mascot

"Mascot" wrote:

I have a table that looks like the following example.

Date LOC ACCT Beg Bal Activity Ending
May-06 M101 1001 10.00 210.00 310.00
May-06 M101 1002 20.00 220.00 320.00
May-06 M101 1003 30.00 230.00 330.00
May-06 M101 1004 40.00 240.00 340.00
May-06 M101 1005 50.00 250.00 350.00
Jun-06 M101 1001 60.00 260.00 360.00
Jun-06 M101 1002 70.00 270.00 370.00
Jun-06 M101 1003 80.00 280.00 380.00
Jun-06 M101 1004 90.00 290.00 390.00
Jun-06 M101 1005 100.00 300.00 400.00
May-06 M102 1001 110.00 310.00 410.00
May-06 M102 1002 120.00 320.00 420.00
May-06 M102 1003 130.00 330.00 430.00
May-06 M102 1004 140.00 340.00 440.00
May-06 M102 1005 150.00 350.00 450.00
Jun-06 M102 1001 160.00 360.00 460.00
Jun-06 M102 1002 170.00 370.00 470.00
Jun-06 M102 1003 180.00 380.00 480.00
Jun-06 M102 1004 190.00 390.00 490.00
Jun-06 M102 1005 200.00 400.00 500.00

I have a spreadsheet that I need to fill out every month in a specific
format so I need to have something that will pull info from this table so I
dont have to type it in by hand every month. For example I may need to
have a specific DATE, LOC, ACCT and then the amount in one of the three
columns (Beg Bal, Activity, Ending Balance). Oh also the DATE may be because
it will change every month so I should probably link it to a date4 cell. Let
me know if any of you have any ideas.

Thanks
Mascot

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do a create a lookup using first and last name	Teric506	Excel Worksheet Functions	2	December 15th 09 05:53 PM
How to create a macro to help with lookup.	Jman	Excel Worksheet Functions	3	May 30th 07 05:55 AM
Does anyone know how to create a lookup that will do this?	Mascot	Excel Worksheet Functions	3	July 26th 06 01:54 PM
Does anyone know how to create a lookup that will do this?	Mascot	Excel Discussion (Misc queries)	2	July 25th 06 08:51 PM
how do i create a lookup	RaPiDfIrE	Excel Discussion (Misc queries)	1	May 10th 05 08:31 PM

Menu

About Us