this is probably very basic but i cant figure it. i have an excel work book with two work sheets.
Work sheet one is a list of purchase orders with a reference number beginning PO and then a 5 digit no
Sheet 2 is a list of invoices and one column is reserved to show the purchase order the invoice was raised on.
What i want to do is, in sheet one have a column that shows 1 if the purchase order number appears in the column on the next sheet or 0 if it doesnt.
basically what i want to do is get excel to try match the number in a given cell to the same number in a column on the next work sheet.
any ideas?
Work sheet one is a list of purchase orders with a reference number beginning PO and then a 5 digit no
Sheet 2 is a list of invoices and one column is reserved to show the purchase order the invoice was raised on.
What i want to do is, in sheet one have a column that shows 1 if the purchase order number appears in the column on the next sheet or 0 if it doesnt.
basically what i want to do is get excel to try match the number in a given cell to the same number in a column on the next work sheet.
any ideas?
