how do I attache a file to a new thread to let people see what I am trying to do

[rustybenson]

Hi,
I have a spread sheet I am having probles with however it is difficult to explain. Can I attach the file so helpers can view?
I keep getting #n/a.

 

[Pediez]

You may use 3rd party sites like http://www.filefactory.com/
to upload and share files....
However i think explaining what you want to do will be alright

 

[rustybenson]

Thanks for the info
Here goes. This is in a daily stock reconcilliation work book with 31 sheets(1 for each day). It shows stock in and stock out and provides a daily balance. Each day we receive apprx. 4 shipments. and sell similar (the oldedt first)
In sheet 1 D14 to d27 I have a list of shipment numbers (not all rows are used all the time)
In e 14 to e 27 I have litres of fuel for the shipment. In f14 to f27 I have the sales of fuel from those shipmets. (the driver records the sales as he delivers and when a shipment litres is used he then starts selling the next shipment and so on). I have other info accross the colums however i rows Q14 to Q27 I have the balance of any litres not sold from a shipment.
New shipments are comming in to the depot and shipments there are being sold so the list change each day(some come some go however there are some that can be there up to 8-9 days.
I am trying to carry forward the remaining amounts of shipments unsold till the next day so i can balance the shipmet sales.
My formular is =VLOOKUP(D14,Sheet1!$D$14:$Q$27,14,FALSE) however this brings up #n/a because if a new shipment comes in today it is not on yesterdays list so the formula can't see it. I have also tried index/match with the same result.
This formula is in rows c14 to c27.