VLookup not working

[vba317]

I am working in excel 2003. I have tried to write a Vlookup column that I can't get to work. I originaly tried to write code that I also can't get tot work so I am trying to use a Vlookup instead. What I am trying to do is I have three columns the First Column is the A Column. The Second Column is the AB Column. The Value Set is in the AC Column. The value would go in the Q Column. What I would like to happen if possible is this. With the current data A6 = AB9 the value that is in AC = 128. I would like 128 to be in cell Q6.
Any help is appreciated.

Tom

 

[vba317]

Sorry,
Forgot the Formula.
=VLOOKUP(A:A~AB:AB~AC:AC~FALSE) This Formula is in Cell Q6. I am getting an #Ref Error.

 

[dhookom]

Please ask Access questions in this forum, not Excel. You might want to try the Office forum.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

I'd ask here: forum707

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vba317]

Sorry about that I will repost