B
bdent
I am trying to use vlook up and I am pulling the information from another
spreadsheet and I am getting a #REF.
spreadsheet and I am getting a #REF.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
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.
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.
T
tim m
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?
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?
B
bdent
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.
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.