Which formula do you know in excel Get this value usinhlg vlookup What is vlookup and its argument Use of concatenate formula Extract only day in date time formate

Question

Accepted Answer

VLOOKUP is a formula in Excel used to search for a value in a table and retrieve corresponding data from another column.

VLOOKUP is used to find an exact or approximate match in a table.
Its arguments include the lookup value, table range, column index, and match type.
Concatenate formula is used to combine text from multiple cells into one cell.
It is helpful for creating unique identifiers or joining data from different cells.
To extract only the day from a date-time format, use the DAY function in Excel.

Accepted Answer

it is a function that makes excel for a certain value in a column (the so called 'table array'), in order to return a value from a different column in the same row.

Accepted Answer

The VLOOKUP function is a premade function in Excel, which allows searches across columns. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Accepted Answer

The VLOOKUP function is a premade function in Excel, which allows searches across columns. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Which formula do you know in excel Get this value usinhlg vlookup What is vlookup and its argument Use of concatenate formula Extract only day in date time formate

Popular interview questions of MIS Executive

Top HR questions asked in Tata Capital MIS Executive