+ Reply to Thread
Results 1 to 2 of 2

Google sheet: index match

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    671

    Google sheet: index match

    Hi guys

    Please srefer to my sheet, here:

    https://docs.google.com/spreadsheets...it?usp=sharing

    TAB: Predicted scores whatsapp

    I have used text to columns to split up scores into seperate cells i.e. B5 and C5. i WANT to know if it's possible to use a index match to pick up the scores and inputting them in cells T7 and T8, matching the name above T7 and T8 which is also in A5 (I will remove the icons)

    Thanks so much
    Thanks,

    R.



  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,597

    Re: Google sheet: index match

    What's not working?

    If you remove the icons then the formula should work.

    The only other problem I can see is that you would need to make the column references absolute and use row 2 to get the name to lookup

    So in T7 you would have this,

    =INDEX($B$5:$B$42, MATCH(T2,$A$5:$A$42,0),0)

    and in V7 this.

    =INDEX($C$5:$C$42, MATCH(V2,$A$5:$A$42,0),0)
    If posting code please use code tags, see here.

+ 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. [SOLVED] Index First Three Results That Match Criteria In Google Sheets
    By swordswinger710 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-27-2019, 05:06 PM
  2. Index/Match Help - Google Sheets
    By JenMasters84 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 04-25-2018, 02:52 PM
  3. Index/Match possibly? Match data from one sheet to another
    By kg0332 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2018, 05:29 PM
  4. Replies: 2
    Last Post: 03-07-2017, 04:35 PM
  5. Replies: 1
    Last Post: 06-18-2015, 08:45 AM
  6. Replies: 9
    Last Post: 11-07-2014, 07:10 AM

Tags for this Thread

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