I have a query that returns multiple rows per each key used. Each key has a different quantity that I would like to use as a factor to multiply each row by. I would like every result to be multiplied by the same factor set to KEY 1.

For example, all 3 cells in the multiply column for Key "45492" I would like multiplied by 1,600. I have the query used posted here, and the complete sheet too. I created a "TEST PAGE" that has all the necessary information to recreate a complete, usable function.

CodePudding user response：

try:

=INDEX(IF(E3:E="",,G3:G*IFNA(VLOOKUP(E3:E, B3:C, 2, 0))))