Useful MS Excel Tools

less than 1 minute read

Compare multiple columns together for equality

=AND(EXACT(A1:D1,A1))

Hit ^Ctrl ⇧Shift ↵Return to get the result, if the cell values are equal, it will display TRUE, otherwise, it will display FALSE,

Comparing two cells

=EXACT(A1,D1)

Make a String in camel case.

The columns to be searched should be the First column Also, if there are multiple values, then only the first one in the order wil be returned

=VLOOKUP arguments

Scenario: Column X and Y are present in a large set of Data. If a few valus of X is given, find the corrosponding values of Y against X.

Solution: Column X(present in a Range or in a Table, as first Column) and Y (using VLOOKUP)

First argument is the value to lookup in the large set of data.
Second argument is the range or table to look for the value.
Then, the index of the column where the lookup value is located (indexing begins from 1 for X)
Finally FALSE to find an exact match.