Hello,
I'm trying to assist a colleague with automating a customer invoice by matching a part number from one worksheet to another and then calculate the amount $ based on quantity ordered from the second worksheet.
Im not sure if the attachments make sense?
I tried a index, match, match but had to change the way the catalogue table looked and I would prefer to keep the table like the attached example if possible.
So any help would be greatly appreciated.
Example.xlsx
Bookmarks