Hi,

I have a workbook, one sheet for purchase orders, which collects data from
the Stocklist sheet (excel 2003). I want to insert a vlookup formula into
cell B10 of the PO, dependant upon a code i type into cell A10 of the PO,
which brings across the corresponding description, then the same formula,
ammended, to bring across the corresponding size into D10, price into E10. I
tried this but it had too many arguments:
=IF($A$10="","",VLOOKUP(StockList!$A10,$A10:$H1001 5,COLUMNS($A$3:B10),2,0))

--
Regards,
Sarah