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
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