How do I use vlookup?



How do I use vlookup?..

Answer / Dharam Singh

To use VLOOKUP, you specify the range where you want to search for a value (lookup_value), another range that contains the data to be searched (table_array), and the column number within the table_array that holds the desired return values (col_index_num). Here's an example: `=VLOOKUP(A2, A1:B10, 2, FALSE)`

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How many types of ms excel?

1 Answers  


What is the purpose of the if function?

1 Answers  


What is the function of f5 in excel?

1 Answers  


How do you hide #value in excel?

1 Answers  


How to create a spreadsheet in excel 2013?

1 Answers  


What is conditional formatting in access?

1 Answers  


What is text formula in excel?

1 Answers  


How do I automatically color cells in excel?

1 Answers  


How do I compare two excel documents in office 365?

1 Answers  


What is excel xfd?

1 Answers  


What is the best program to use for making a spreadsheet?

1 Answers  


How do you use the choose function in excel?

1 Answers  


Categories