In this KS1 article you'll learn how to solve multiplication and division problems using an array. We also have a KS1 Maths videos, a quiz and lots of examples.

Enter the formula by which you want to multiply the numbers in the columns. You can enter the formula into any cell, but for this example, assume you enter it in cell C1.

2] Find differences by comparing two columns. Another purpose for the VLOOKUP function is to find differences within two columns. This is an easy task, so let us talk about how to get this done.

How to multiply cells and numbers using the PRODUCT formula. You aren't limited to multiplying just two cells — you can multiply up to 255 values at once using the PRODUCT formula.

FILTER()’s array reference returns the four values in Qrt 2: Susan, Lilly, Kate, and June. The only value that corresponds to a TRUE value is June, so the expression returns June.