Match Two Columns, Only If Another Column Matches and Then Multiple by Two Other Columns

[yc77777]

Hey guys I seem to be stumped!

I have a spreadsheet with two Sheets. I am trying to match Sheet 2 Column B to Sheet 1 Column E, only if Sheet 1 Column C = “Order” – Then I want to take Sheet 1 Column G and multiple it by Sheet 2 Column R

Sheet 1

Column E – 1000 lines with text

Column C – 1000 lines with text

Column G – 1000 lines with numbers

Sheet 2

Column B – 1000 lines with text

Column R – 1000 lines with numbers



My brain nearly exploded just writing this post.

Any direction would be appreciated!

Thanks in advance

 

[Peter_SSs]

Welcome to the MrExcel board!

What about you make up a small set of dummy data for each sheet (say 10-15 rows should do?), enter the results that you want manually? Post both those sample sheets here with XL2BB and then explain again in relation to those samples?
That way helpers will have a much better idea of just what you have, where it is and what you are trying to achieve and will be able to easily copy that sample data for testing