IF function

=IF(‘Daily Sales’!I7:I12=Stocks!H7,’Daily Sales’!B7)

Sheet1 is Stock Records, Sheet2 is Daily Sales Records. I use =Concatenate to give each Item a unique name. and ‘Stock Records’!H7 has a unique name for example “COLOURNP-014” using the above IF function, it display the date i put on ‘Daily Sales’!B7 but I need a formula that would put the date on Stock Records sheet when i put a date anywhere in ‘Daily Sales’!B column when I sold “COLOURNP-014” it could be B7 or B84.

By: Cham

Leave a Reply

Your email address will not be published. Required fields are marked *