Logo 
Search:

MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

Explain IF ,Vlookup, Hlookup function.

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 2635

Answer:

IF : The IF worksheet function checks a condition that must be either true or false. If the condition is true, the function returns one value; if the condition is false, the function returns another value. The function has three arguments: the condition you want to check, the value to return if the condition is true, and the value to return if the condition is false.
=IF(logical_test,value_if_true,value_if_false)
Vlookup : Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table.
=VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Hlookup : Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.

= HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)

Share: 
 

Didn't find what you were looking for? Find more on Explain IF ,Vlookup, Hlookup function. Or get search suggestion and latest updates.


Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: