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!