Excel formulas to club two cell values and what are limitations of VLOOKUP formula.

Question

Accepted Answer

Excel formulas to club two cell values and limitations of VLOOKUP formula.

To combine two cell values in Excel, you can use the CONCATENATE function or the ampersand (&) operator.
Example: =CONCATENATE(A1, B1) or =A1&B1
VLOOKUP is a powerful Excel function used to search for a value in a table and return a corresponding value from another column.
Limitations of VLOOKUP include: it only searches in the leftmost column of the table, it requires the lookup column to be sorted in ascending order, it cannot search for values to the left of the lookup column, and it only returns the first matching value.
Example: =VLOOKUP(A1, B1:C10, 2, FALSE)

Popular interview questions of Team Lead Operations