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.  
  2. So, if you want to get the address of Toshiba. we can do it like this.
    3. =VLOOKUP("Toshiba",A1:C4,2,FALSE)
    Note: lookup_value is not case sensitive.

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















Comments

Post a Comment

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,
Post a Comment
Read more

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
2 comments
Read more

Windows CE install/update/upgrade/restore

Windows CE install/update/upgrade/restore to factory default. I am having a problem with my wireless book(Netbook or Pocketbook) w/ windows CE 6.0 it was stuck at "Loading Drivers" and nothing happens afterwards. The only solution i can think is to reinstall WinCE 6.0 Prepare:     - 1GB SD Card (Format it as Normal not Quick in FAT)       - Charge the battery of Netbook up to 100% (in my experience, installation may failed if low battery)     - Download  WinCE 6.0 or in http://www.poodwaddle.com/netbook/WinCE.rar      - Extract that file into SD Card root folder (when you open you SD Card in explorer you can see that there is folder named "Script".    - That's all for the preparation Procedure:     1. Turn-off Netbook     2. Insert the SD Card     3. Turn-on netbook     4. It will automatically read and execute the content of the SD Card     5. It will restart automatically and load the software package, and you can see ang windows deskto
1 comment
Read more