+ Reply to Thread
Results 1 to 11 of 11

Vlook up

Hybrid View

mahershams Vlook up 11-28-2013, 03:30 AM
mahershams Re: Vlook up 11-28-2013, 03:33 AM
HaHoBe Re: Vlook up 11-28-2013, 03:56 AM
brandedadnan Re: Vlook up 11-28-2013, 04:04 AM
mahershams Re: Vlook up 11-28-2013, 04:52 AM
mahershams Re: Vlook up 11-28-2013, 04:00 AM
mahershams Re: Vlook up 11-28-2013, 04:01 AM
HaHoBe Re: Vlook up 11-28-2013, 04:06 AM
mahershams Re: Vlook up 11-28-2013, 04:51 AM
  1. 11-28-2013, 03:30 AM #1
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Vlook up

    Dear all

    My vlookup command gives me #N/A. My vlook up variable is 149441MaxiTRANS Industries Ltd38047 and it is available in the dataset 149441MaxiTRANS Industries Ltd38047. Can you please advice me where it went wrong.



    =VLOOKUP(E2,'[M&A without Insider Trading_Parent company details.xlsx]Insider trading database'!$A$4:$AJ$3132,33,0)

    Thanks
    Shams
    Last edited by mahershams; 11-28-2013 at 03:32 AM. Reason: upload file
    Reply With QuoteRegister To Reply
  2. 11-28-2013, 03:33 AM #2
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Vlook up

    Hi vlookup excel is attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 11-28-2013, 03:56 AM #3
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Vlook up

    Hi, mahershams,

    item has to be found in the first column of the search matrix (in your sample that should be Column E, not A). If it´s located in another column than the first one use Index/Match instead of VLookup.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  4. 11-28-2013, 04:04 AM #4
    brandedadnan is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    Kuwait
    MS-Off Ver
    Excel 2013
    Posts
    115

    Re: Vlook up

    Hello mahershams,
    Pls find the attached file.

    I think we can get answer using iferror, index,match
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 11-28-2013, 04:52 AM #5
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Vlook up

    Hi Brandedadnan

    Thank you very for your solution. But if you have time please explain why vlookup unable to retrieve the data.

    Regards
    Shams
    Reply With QuoteRegister To Reply
  6. 11-28-2013, 04:59 AM #6
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Vlook up

    Hi, Shams,

    I have no idea why your or mine vlookup command do not work
    Altered formula for P2:
    Formula: copy to clipboard 
    =IFERROR(VLOOKUP(E2,Sheet1!$E$1:$AJ$8,29,0),"")

    Have a look at the attachment - works fine for me.

    Ciao,
    Holger.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 11-28-2013, 04:00 AM #7
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Vlook up

    Hi HahoBe

    May be I did not get you. When I use E4 instead of A4, now it shows #REF!

    Please suggest me.

    Regards
    Shams
    Reply With QuoteRegister To Reply
  8. 11-28-2013, 04:01 AM #8
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Vlook up

    Hi Hahobe

    Does it mean that vlookup could not able to retrieve the data without match function. Would you be able to advice me?
    Reply With QuoteRegister To Reply
  9. 11-28-2013, 04:06 AM #9
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Vlook up

    Hi, Shams,

    Formula: copy to clipboard 
    =VLOOKUP(E2,Sheet1!$E$1:$AJ$8,29,0)

    for Sheet2 Range P2.

    Ciao,
    Holger
    Last edited by HaHoBe; 11-28-2013 at 04:07 AM. Reason: edited formula to show english version
    Reply With QuoteRegister To Reply
  10. 11-28-2013, 04:51 AM #10
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Vlook up

    Hi Ciao

    I have no idea why your or mine vlookup command do not work. However the solution provided by Brandedadnan is retrieving the data successfully.

    However thanks for your effort.

    Regards
    Shams
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlook up
    By isasa74 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2013, 05:46 AM
  2. [SOLVED] Vlook UP
    By joh46k in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-29-2013, 02:47 AM
  3. [SOLVED] Vlook ups help please
    By TrainerJ in forum Excel General
    Replies: 9
    Last Post: 04-26-2012, 09:35 AM
  4. [SOLVED] Vlook
    By bimseun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2006, 06:55 PM
  5. [SOLVED] vlook up
    By arcticale in forum Excel General
    Replies: 1
    Last Post: 01-25-2006, 05:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1