VLOOKUP / MATCH cell selection error

[BBallard]

HI!
I am using a vlookup/match to populate fields from column headers. For the most part it's doing exactly what I need except instead of pulling column 2 twice and not pulling column 7.

code I am using:
=VLOOKUP($A$10,$A$2:$G$6,MATCH(B9,A1:G1,0)0)

I copied the code across the columns it looks right to me, but it pulls columns
2,2,3,4,5,6

Help! Thanks!!

 

[Joyner]

If the return value is always text, try:

=T(VLOOKUP($A$2,Sheet2!$A$2:$O$77,MATCH($B1,Sheet2!$A$1:$O$1,0),0)))

 

[BBallard]

This worked perfectly! Thank you so much!!!!