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

 

[SkipVought]

hi,

Your formula?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

It appears that this is the forula you posted originally in an Access forum...
[tt]
=VLOOKUP(A:A~AB:AB~AC:AC~FALSE)
[/tt]
1) The first argument should be a single value. You have a range!
2) The third argument should be a NUMBER OFFSET value. You have a range!
3) Why do you use the TILDA character, rather than a COMMA?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[byundt]

I think that you want to find the value that is in cell A6 in the AB column, then return a value from the same row in the AC column. If so, the formula would be:
=VLOOKUP(A6,AB:AC,2,FALSE)

The FALSE means that the data in column AB has not been sorted and that an exact match for A6 is required. The 2 means that you want a value from the second column in the range AB:AC (i.e. column AC).

Brad