Skip to main content

Search Value from the list (Excel VLOOKUP Function)

Excel VLOOKUP Function

Syntax: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Scenario: You want to check if a certain word exists from the list and get the corresponding  row value.

Procedure:
  1. Select the array of data.In below image I selected  A1 to C4 .
  2.  
  3. So, if you want to get the address of Toshiba. we can do it like this.
  4. =VLOOKUP("Toshiba",A1:C4,2,FALSE)
    Note: lookup_value is not case sensitive.

  5. if you want to get the price of Toshiba. we can do it like this.
  6. =VLOOKUP("Toshiba",A1:C4,3,FALSE)
    We only change the col_index_num into 3.















Comments

Popular posts from this blog

Bundy Clock Quick Setup Manual for IWATA TIME RECORDER CW-1A, CW-2A, CW-2SA

Recently, I bought IWATA bundy clock for our office and I'm happy because there is a Quick Setup Manual included in the package which is hard for me to find/download from the internet. Then I realized that it might be useful in the future so I decided to upload the manual here. Thanks,

Bundy Clock Set Time (IWATA CW-1A)

if the time is advance    * Press "HO" button once to stop the timer    * Press "HO" button again to start the timer if the time is late    * Press "SY" to add 1 minute UPDATE: I have already a copy of Quick Setup Manual for IWATA Bundy Clock. CLICK HERE

SONY Ericsson XPERIA E15i (HARD RESET)

METHOD 1: a. Turn off your phone b. Press and hold LEFT, RIGHT and POWER buttons until the factory reset menu appears c. Select Wipe Data d. Reboot/Restart your phone. METHOD 2: (proven effective) a. Download SONY PC COMPANION 2.1 here b. Install it into your PC and run the program c. On "SUPPORT ZONE" panel, click "Start" d. On  "Phone / Tablet Software update", click "Start" e. Click "Repair my Phone / Tablet" f.  Click "Continue" g. Tick the box "I understand.." and click "Next" h. Tick the box "I understood..." and click "Continue" i. Tick the box on "Battery Level Info" and click "Next" j. Select you phone model in the selection and click "Next" h. Connect you phone to PC       h-1. Turn off you phone and wait for 5 seconds      h-2.  Connect your Phone to the PC while pressing the Back Button (Left Button) using USB Cord. i. F...