stock control

Hi all thanks for accepting me to this forum your help would be much appreciated

im currently trying to create a spreadsheet for fuel control stock for 3 different outlets on the same site using the meter readings collected each morning each outlet has its own workbook and a fourth workbook is an overview of the previous 3 for the accounts team showing year on year and graphs and data so far so good.
but i have been asked to produce a stock tab where it will automatically display the current dates stock is there a formula for this

kind Regards
Steddas

You could use...

B4 =INDEX(AVGAS!F6:F17,MATCH(A4,AVGAS!E6:E17,0))
C4 =INDEX(AVGAS!C6:C17,MATCH(A4,AVGAS!B6:B17,0))
E4 =INDEX('JET A1'!C6:C17,MATCH(A4,'JET A1'!B6:B17,0))

A4 in the formulas above on the Stock Levels tab equals Feb
------------------------------------------------------------------------------------
Actually, you can also just use a Vlookup

B4 =VLOOKUP(A4,AVGAS!E6:F17,2,0)

You have three versions of this thread running. Please continue here: http://www.excelforum.com/excel-gene...ck-sheets.html

Thread closed.