+ Reply to Thread
Results 1 to 3 of 3

Inserting matched data from another table

  1. #1
    Registered User
    Join Date
    03-19-2010
    Location
    Estonia
    MS-Off Ver
    Excel 2016
    Posts
    25

    Inserting matched data from another table

    Hello!
    Can someone help me to make a formula that finds value from another table based on station name? I have tried using match and lookup function, but I can't get it work.

    Station Latitude Longitude Other data
    1a ? ?
    4a ? ?
    2a ? ?
    3a ? ?
    1a ? ?
    2a ? ?

    1a 57.42342 29.54323
    2a 56.78943 28.34257
    3a 57.93653 28.57217
    4a 58.19241 29.63312

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,785

    Re: Inserting matched data from another table

    try this in B2
    =VLOOKUP(A2,$A$9:$C$12,2,0)

    and
    =VLOOKUP(A2,$A$9:$C$12,3,0) in column C2
    and fill down

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  3. #3
    Registered User
    Join Date
    03-19-2010
    Location
    Estonia
    MS-Off Ver
    Excel 2016
    Posts
    25

    Re: Inserting matched data from another table

    Thank You very much! I will write the solution next to computer, so it is always visible.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inserting Data table between duration of dates
    By soleimani1967 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2015, 03:08 AM
  2. Replies: 10
    Last Post: 09-16-2015, 11:25 PM
  3. Help with table lookup using matched text
    By staticsnake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2014, 01:33 PM
  4. Inserting data from pivot table into another worksheet
    By Destiny2013 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-19-2013, 09:32 PM
  5. Continue looking in a table if 1st matched cell is blank
    By patchulee in forum Excel General
    Replies: 5
    Last Post: 07-06-2011, 10:01 AM
  6. Excel 2007 : Inserting Data Table Below Chart
    By Scotty7491 in forum Excel General
    Replies: 1
    Last Post: 09-28-2010, 10:43 PM
  7. Display matched table data in another sheet
    By vanir in forum Excel General
    Replies: 2
    Last Post: 08-30-2009, 09:02 PM

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