+ Reply to Thread
Results 1 to 3 of 3

data_extraction

  1. #1
    Registered User
    Join Date
    10-08-2015
    Location
    usa
    MS-Off Ver
    2013
    Posts
    1

    Post data_extraction

    I want to extract some value according to station id.

    Station ID Rainfall Evaporation

    A 10 1

    B 20 2

    C 30 2

    I want to extract all values corresponding to station B. How can i do it?

  2. #2
    Valued Forum Contributor Kamboj's Avatar
    Join Date
    09-25-2014
    Location
    India
    MS-Off Ver
    2003 - 2010
    Posts
    430

    Re: data_extraction

    With the help of Vlookup you can extract the data
    =VLOOKUP("A",A2:C4,1,TRUE)
    Kamboj
    _________________________________________________________________________________
    Mark the thread as SOLVED if my answer satisfy you.

  3. #3
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: data_extraction

    Hi,

    Welcome to forum,

    You can try this formula =VLOOKUP($E$2,$A$2:$C$4,MATCH(F$1,$A$1:$C$1,0),0)

    Have a look in attached sheet.
    Attached Files Attached Files
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1