Complete newbie that doesnt know what category this problem should be in, very sorry

[cloudStrife69]

Hey people, so I have 3 excel sheets, one has the product details, second has the order details, and the last the total profits details.
In the product details sheet, there's the pricing for each product with different IDs called SKU , and so I would like to insert the
pricing of each product into the order sheet according to the product ID, the product ID will already be in the order sheet, then
I would like to multiply the cost of each product in the order by its quantity which will already be given in the excel sheet
and create a new column in total cost for the product but there's
too many of the orders and products and manually inserting by myself is really physically taxing is there any function or any way in
Excel to make my work easier?

Also, after inserting the costs into the order sheet, I would like to compile the total costs for each order and then insert the total costs
into the total profits sheet according to the order ID of course, after that there will be a total release amount column to subtract the total
cost and create a new column called total profits for each order so again is there any other way of making this work easier?

I have learnt Python programming albeit not at industry level yet so if there is no function in excel that can help me with this,
are there any other ways I can explore using Python programming on Excel?

Below are the excel sheets I mentioned

Help would be very much appreciated as you saved my sanity
Thank you

 

[Candyman8019]

What version of excel are you using? If it is newer the XLOOKUP function should do what you’re looking for. If you have an older version of excel we would need to do an INDEX/MATCH function.

 

[cloudStrife69]

What version of excel are you using? If it is newer the XLOOKUP function should do what you’re looking for. If you have an older version of excel we would need to do an INDEX/MATCH function.

I think its Microsoft 365 MSO

 

[Candyman8019]

In that case XLOOKUP is your best bet. Give it a try and see if that works for you. If you're stuck then use XL2BB to provide a sample of your spreadsheet including columns/rows, etc and we can give you a hand.

 

[cloudStrife69]

In that case XLOOKUP is your best bet. Give it a try and see if that works for you. If you're stuck then use XL2BB to provide a sample of your spreadsheet including columns/rows, etc and we can give you a hand.

Noted, will look it up haha thx for the help