Lookup Function for Alpha-numeric Text

[pmrich]

I am attempting to lookup values from one worksheet and populate a few fields on a different worksheet within the same workbook. Our code is a six digit alpha-numeric code, indexed. I have created a large pivot table, which has all the detailed data I require in worksheet 1. I would like, however, to cross reference and add three columns of demographic information from worksheet 2. I plan to add the three columns one by one.

I tried this VLOOKUP formula: =VLOOKUP(A6,Worksheet2!$A$1:$Q$8867,Worksheet2!$L$2:$L$8867,FALSE)

My results are either #N/A (which I believe to mean that there is not a data match, this is OK) or #REF! (which I know means I messed up somewhere). I have almost 1000 lines of data, so I don't want to type in the six digit code each time for the text lookup.

Suggestions appreciated! Thanks!

[NBVC]

=VLOOKUP(A6,Worksheet2!$A$1:$Q$8867,Worksheet2!$L$2:$L$8867,FALSE)

the part in red should be a number representing the column number to get the corresponding data from....

[pmrich]

Wow, you just hit the "Easy" button on that one! Thanks, I had been struggling on that formula !