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

My guess...

Your look up range isn't wide enough.

=vlookup(a1,sheet2!a:c,6,false)
will return an error since I'm trying to retrieve column 6 of a 3 column range.

bdent wrote:

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

--

Dave Peterson

You have a column with account codes in sheet 1 and a column right next to it
with locations and in sheet 2 you just have locations? Or do you just have
the accout codes in one sheet and just the locations in another sheet?

"bdent" wrote:

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.

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.