How to use Vlook up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlook UP 1
vlook up 1
How do I use drop down list selections/values in a vlook up formu. 2
V Look up Link problem accross different workbooks 1
VLookup in Excel 2007 - question on setup 2
formula for if and v look up for 2 values 3
use vlook to show the value of a cell using a formula 5
Reverse VlookUp 1

Back
Top