Hi everyone,

I need to do following in my own created excel invoice:

I do have an invoice that is created by Lookup and Vlookup functions. The final invoice is based on invoice number, that means if I change invoice number, total invoice related to that number is created automatically.

Question: Now I need to list all of my invoice numbers with related information (purchaser, total cost, my benefit) in separate sheet. To do it I need a function that will replace a given invoice number in new sheet with the invoice number in invoice sheet and return the related total cost, purchaser and benefit on that particular invoice. any one can help me on that?

related picture:
https://ibb.co/g9j1Xv