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.

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

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.

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.

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.