+ Reply to Thread
Results 1 to 11 of 11

Return multiple values horizontally using vlookup

  1. #1
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Return multiple values horizontally using vlookup

    Hi

    I've been messing around with vlookup and it functions, as typed in title I need help with multible values. I have made a simple one sheet formula, but I cant seem do expand it to multiple sheets or make it more advanced.

    Basically I just need to do a vlookup and return 2 values.
    I hope my example will clear thing up.
    I would appreciate any help or simpler formulas, because right now I'm just stuck

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Return multiple values horizontally using vlookup

    Your formula is perfect and not sure what you are still trying to achieve


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Return multiple values horizontally using vlookup

    Hi,

    Since your results for Style1 and Style2 are on separate sheets, you can just perform two separate lookups for each track. So, in cell D23 of your Main tab:

    =IFERROR(VLOOKUP(A23,Sheet1!$A$2:$D$10,4,0),"")

    and in cell E23:

    =IFERROR(VLOOKUP(A23,Sheet2!$A$2:$D$6,4,0),"")

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Return multiple values horizontally using vlookup

    Oh sorry I forgot to add that the first formula is just and example and I need help on Main sheet

  5. #5
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Return multiple values horizontally using vlookup

    Quote Originally Posted by XOR LX View Post
    Hi,

    Since your results for Style1 and Style2 are on separate sheets, you can just perform two separate lookups for each track. So, in cell D23 of your Main tab:

    =IFERROR(VLOOKUP(A23,Sheet1!$A$2:$D$10,4,0),"")

    and in cell E23:

    =IFERROR(VLOOKUP(A23,Sheet2!$A$2:$D$6,4,0),"")

    Regards
    Thanks for so quick reply but the thing is that I have more then 2 sheets do look from(14 :D) and only need do see if they double somewhere. Thats why I need 2 style coulums
    Last edited by ThatGuyinBLue; 07-03-2013 at 04:17 AM. Reason: added info

  6. #6
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Return multiple values horizontally using vlookup

    Sorry for sounding obvious, but why can't you amalgamate the 14 sheet tables into one table on one sheet?

  7. #7
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Return multiple values horizontally using vlookup

    Quote Originally Posted by XOR LX View Post
    Sorry for sounding obvious, but why can't you amalgamate the 14 sheet tables into one table on one sheet?
    I update them from text files so it easy on the eyes and avoids dublicates when updating or just my mistakes, dont get me wrong all in one would be easier with formulas.

  8. #8
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Return multiple values horizontally using vlookup

    I think I have typed a bit of confusing text so thanks for all your replys, but I'll delete this and make a new more informative and clear post.

  9. #9
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Return multiple values horizontally using vlookup

    Are all your 14 sheets named e.g. Sheet1, Sheet2, ..., Sheet14 (or some other text in place of Sheet, but with 1-14 appended)? If you can make it so, and, assuming that your tables in each of those sheets will begin in row 1 columns A-D, then, in cell D23 and to copy across and down:

    =IFERROR(VLOOKUP(A23,INDIRECT("Sheet"&COLUMNS($A$1:A$1)&"!$A$2:$D$100"),4,0),"")

    where 100 is an arbitrary row number which you should change to ensure it is greater than or equal to the last row containing data in your 14 tabs.

    Regards

  10. #10
    Registered User
    Join Date
    09-17-2012
    Location
    Estonia
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Return multiple values horizontally using vlookup

    Quote Originally Posted by XOR LX View Post
    Are all your 14 sheets named e.g. Sheet1, Sheet2, ..., Sheet14 (or some other text in place of Sheet, but with 1-14 appended)? If you can make it so, and, assuming that your tables in each of those sheets will begin in row 1 columns A-D, then, in cell D23 and to copy across and down:

    =IFERROR(VLOOKUP(A23,INDIRECT("Sheet"&COLUMNS($A$1:A$1)&"!$A$2:$D$100"),4,0),"")

    where 100 is an arbitrary row number which you should change to ensure it is greater than or equal to the last row containing data in your 14 tabs.

    Regards
    Wow, you might have just solved my problem, and if not then made it easier do solve, thanks a lot for that. I'll but my brains to work now again thanks for your help.

  11. #11
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Return multiple values horizontally using vlookup

    No worries. Let me know how you get on.

    Cheers

+ 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