How to Analyze Data with Logical and Lookup Functions-MS Excel 2007….!!!!

0

How to Analyze Data with Logical and Lookup Functions-MS Excel 2007

Method-1: Insert a Logical Function

To insert a Logical function in a worksheet:

            1.       Select the cell into which the function will be placed.

            2.       Enter the Logical function.

            3.       If necessary, in the Function Arguments dialog box, enter the arguments required and then click OK.

Method-2: Look Up Data with HLOOKUP or VLOOKUP Function

To look up data with the HLOOKUP or VLOOKUP function:

            1.       Select the cell into which the HLOOKUP or VLOOKUP function will be placed.

            2.       Using the formula entry method of your choice, enter the HLOOKUP or VLLOKUP function name.

            3.       Using the arguments entry method of your choice, enter the arguments: Lookup value; Table Array; Roe index number or Column Index number; and Range Lookup value (optional).

            4.       If necessary, press Enter to complete the entry of the function.

………………………….Thanks everyone

Share.

About Author

Avatar

Leave A Reply

CAPTCHA ImageChange Image