What is the use of lookup function in excel?



What is the use of lookup function in excel?..

Answer / Anupriya Ekka

The LOOKUP function in Excel is used to find a specific value within an array or range and return a corresponding result. The syntax for VLOOKUP is: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I put password to protect my entire spreadsheet so data cannot be changed?

1 Answers  


How we can use vlookup in excel with example?

1 Answers  


What are the 3 types of cell references in excel?

1 Answers  


I have several objects that are in my excel spreadsheet. They are pictures, charts, text boxes; simply a variety of objects to make my spreadsheet look attractive. It israther difficult to align many of these objects. Is there an easier way than to move objects independently?

1 Answers  


How do I create a string in excel?

1 Answers  


How do you combine text in excel?

1 Answers  


What is the shortcut to fill color in excel?

1 Answers  


Is there a hotkey to merge cells in excel?

1 Answers  


How do you use an if function in excel?

1 Answers  


What is a formula in excel?

1 Answers  


How can calculate age in excel?

1 Answers  


How do I merge cells in sheets?

1 Answers  


Categories