I have a column named account codes in one sheet each account code has a
location that it is matched with. I have a list of locations in another
spreadsheet. I want to place the locations next to the account codes, since
there are hundreds and copy and pasting would be time consuming I thought
this would be the best way, but I can't get it to work.

"tim m" wrote:

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.