Can you give us a sample of the type of data you are working with or at least
post your formula?

"bdent" wrote:

I am trying to use vlook up and I am pulling the information from another
spreadsheet and I am getting a #REF.