+ Reply to Thread
Results 1 to 12 of 12

Google Sheets: Formula Required For Look Up Value

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Google Sheets: Formula Required For Look Up Value

    Hello Everyone , Can anyone help me how to het this result , which formula i need to use ?

    Capture.PNG
    Last edited by AliGW; 06-30-2019 at 05:50 AM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: #Formula Required For Look Up Value

    I don't know if a formula will help you with this, I think you're better off with a macro function which you can then place in a formula
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: #Formula Required For Look Up Value

    Your profile says that you're using excel 2003, but your screen capture is not even excel!
    Given that we don't know which application, or which version of that application that you are actually using, we have no way of knowing what to suggest that will work.
    This array formula works for me, but noting the above, it may not work for you.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

  4. #4
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: #Formula Required For Look Up Value

    Hi Sir , this is a google spreadsheet , can you please chceck in the below link ?

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

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: #Formula Required For Look Up Value

    Google Sheets is NOT Excel

  6. #6
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: #Formula Required For Look Up Value

    but we can apply formulas into that right?

  7. #7
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: #Formula Required For Look Up Value

    You can try the formula that I suggested, that is as much help as I can offer, I don't use google sheets.
    I'll submit a request for your thread to be moved to the correct forum, where someone who does use google sheets might be able to help you.

  8. #8
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: #Formula Required For Look Up Value

    Thank you soo much Sir, i tried ur formula but unfortunately, its give error.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Formula Required For Look Up Value

    Moved to the other platforms section.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: #Formula Required For Look Up Value

    You can use formulas but they must be Google Sheet formulas

  11. #11
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Google Sheets: Formula Required For Look Up Value

    You need concatenate rather than concat. In J4:

    =ArrayFormula(CONCATENATE(IF(INDEX($B$4:$F$9,MATCH(H4,$A$4:$A$9,0),0)<>"",$B$3:$F$3&":"&INDEX($B$4:$F$9,MATCH(H4,$A$4:$A$9,0),0)&CHAR(10),"")))

    and copy down.
    Rory

  12. #12
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Google Sheets: Formula Required For Look Up Value

    Thank you soo much
    Works Perfectly

+ 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. Replies: 8
    Last Post: 06-06-2018, 09:20 AM
  2. Replies: 3
    Last Post: 01-24-2017, 08:08 AM
  3. Replies: 6
    Last Post: 01-17-2016, 09:44 AM
  4. Multiple Vlookup Normal Formula (not array formula) or VBA Function Required
    By BoopathiK in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2015, 03:06 AM
  5. [SOLVED] Simple Conditional Formating Help Required - If Blank then Red Bold text required
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2014, 12:23 PM
  6. Formula required to hide results from another cell formula
    By 917 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2013, 12:12 AM
  7. Formula Required
    By harishs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2011, 07:35 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