Sounds like a VLOOKUP to me.
If you sort your clients data in INV NO order (I'm assuming the supplier will have all the invoices on their ledger), then give it a range name.
You can then put your supplier's invoice listing on the same sheet and use the LOOKUP formula to search for each of your clients invoices in the range you have set up.
If it doesn't find a particular invoice, it will leave a blank cell.
Thanks, but I'm not too familiar with LOOKUPS. I was thinking it might be more suited to a HLOOKUP?? Do you know any good sites or videos?
The first thing to do is create a master list with all your invoice numbers and all their numbers. Then sort it by invoice number. So this will have duplicates at this stage.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?