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]

=VLOOKUP($A$10,$A$2:$G$6,MATCH(B9,A1:G1,0)0)
\

Are you missing a comma at the end?

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


Your formula may be returning TRUE version instead of FALSE

 

[steve the fish]

You need to absolute the A1:G1 in the MATCH.

 

[sheetspread]

B9 and A1:G1 don't have $ in front of them, which means they change as you copy across/down. Adjust and see if you get the correct results. Also be sure that $A$10 should be absolute.

 

[BBallard]

THANK YOU! This is exactly what was wrong. I have been working on this for days!

 

[BBallard]

I had it working perfectly, went back and added in all of my data, and now it is doing the same thing again. Am I just missing something because I have been looking at for so long?

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

Thanks!

 

[BBallard]

Is there a way to leave cells blank if they do not apply to the object in my drop down list instead of it automatically placing a 0 in the cell?

 

[steve the fish]

Yes you arent absoluting A1:O1 in your MATCH. Just the O1 part is absolute reference.

 

[BBallard]

thank you! is there a way to leave the cells blank if they do not apply to the object in my drop down list instead of it automatically placing a 0 in the cell?

 

[steve the fish]

something like:

If(vlookup="","",vlookup)

where vlookup is your current formula without the = sign.