Return multiple values horizontally using vlookup

1. 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

2. Re: Return multiple values horizontally using vlookup

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

3. 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

4. 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. Re: Return multiple values horizontally using vlookup

Originally Posted by XOR LX
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

6. 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. Re: Return multiple values horizontally using vlookup

Originally Posted by XOR LX
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. 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. 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. Re: Return multiple values horizontally using vlookup

Originally Posted by XOR LX
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. Re: Return multiple values horizontally using vlookup

No worries. Let me know how you get on.

Cheers

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

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