Can you apply vloockup, vhoockup in Excel?

Question

Accepted Answer

Yes, I can apply vlookup and hlookup in Excel.

VLOOKUP is used to search for a specific value in a column and return a corresponding value from another column.
HLOOKUP is similar to VLOOKUP, but it searches for a value in a row instead of a column.
Both functions require the user to specify the lookup value, the range of cells to search, and the column or row from which to return the result.
Example: =VLOOKUP(A2, B2:C10, 2, FALSE) will search for the value in cell A2 in the range B2:C10 and return the value in the second column of that range.
Example: =HLOOKUP(A2, B2:F3, 2, FALSE) will search for the value in cell A2 in the range B2:F3 and return the value in the second row of that range.

Popular interview questions of Operations Executive