Google doesn't like the way I'm asking for this:

I have worksheets Red, Blue, & Green. I need to display in Green any rows from Blue who's cell in column A matches a cell Red's column A. I need the full row from Blue; columns go out to BR.

I've tried vlookup but I'm getting errors past the first column & row.

3/12/2015 8:21:29 PM

Vlookup($A1,Blue$A:$BR,2,FALSE) in Green's B1

Vlookup($A1,Blue$A:$BR,3,FALSE) in Green's C1

Vlookup($A1,Blue$A:$BR,4,FALSE) in Green's D1

And so on

[Edited on March 12, 2015 at 9:52 PM. Reason : Then highlight the whole row and click/drag that shit down the page]

3/12/2015 9:50:15 PM