Hi Dav

Column M are Cost Amounts, Column A is the Ref: Number which is unique
and Column B is the name of the customer.

In a seperate document I have a bill template.
Column A called Ref:
Column B called Details
Column C called Costs

I need to fill this information in from the Spreadsheet, so I need a
formula to look up Column M in the Spreadsheet and if there is an
amount in there then enter the amount into Column C of the Template but
I then will need to do a simular Formula to relate Column A and B to
column A and B in the Spreadsheet?

Thanks,


--
VickyC
------------------------------------------------------------------------
VickyC's Profile: http://www.excelforum.com/member.php...o&userid=27391
View this thread: http://www.excelforum.com/showthread...hreadid=516823