Hi,

I have a stocklist (sheet 2) with 4 columns: A= LOT # B=DESCRIPTION C=BIDDER
# D=PRICE, and an invoice (sheet 1) with column A=LOT # containing this
formula: IF(A16="","",VLOOKUP(A16,STOCKLIST!$A$2:$B$501,2.0 )) so the
description comes up automatically in the invoice. Now what i want to do is
have an invoice generated automatically when I enter the bidder number and
price paid into their respective columns, with bidder no.5 generating an
invoice numbered 1005. Row 1 has the invoice no, row 2 has the bidder no. Is
this possible?

Thank you
--
Regards,
Sarah