Include value

[RDx]

I have two sheets,

I need some type of formula that will check if value A1 on sheet2 equals the value of any of the A rows on Sheet1, then if value equals insert next 3 colums of content thats on Sheet1 into Sheet2.

Please help, I need this for fantasy basketball.

[Ikaabod]

You can use this:
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,2,FALSE)
Where the red number is the column (In A-D, where A is 1, B is 2, C is 3, D is 4) to return.
So next to that formula you could enter the following formulas to get the remaining information:
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,3,FALSE)
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,4,FALSE)

[RDx]

Thanks that did the trick.

But I have another problem now, for some reason excel refuses to include the data that is getting with the vlookup into a formula that I have that averages all the values including the ones that vlookup is getting.

This is the formula that I am using =AVERAGE(B2:B3)

B2 has the vlookup formula with the data that it found and B3 has data that I inputed myself. But for some reason excel is not including the data in B2 into the average.

[Ikaabod]

It could be the numbers are being recognized as text. Try multiplying the Vlookup formula's by one. Example:
=VLOOKUP(Sheet2!$A1,Sheet1!$A:$D,2,FALSE)*1