VLookup

V

Vive Hunter

My VLookup argument isn't working. I'm trying to have it lookup the customer
id from my original worksheet in another worksheet, and have it return the
(Co name) value from that second worksheet. When I don't ask it to do an
exact lookup, it returns the correct value, but then when I drag the formula
it just copies it. When I give it a FALSE range lookup for an exact match,
then it won't return the value at all!
I'm using the same vlookup formula that I always use. Here it is:

=VLOOKUP(A2,'COMPANIES.csv'!$A$2:$O$15899,1,FALSE)

What could be the problem? Can anyone help?
 
D

Dave Peterson

First, your formula is bringing back column A of the CSV file.

=VLOOKUP(A2,'COMPANIES.csv'!$A$2:$O$15899,1,FALSE)

I'm not sure what you really meant, but I bet that isn't correct.

Second, if the formula really adjusts (A2 becomes A3 becomes A4 ....), then my
bet is that you have excel in manual calculation mode.

In xl2003 menus, you can toggle that setting:
tools|options|calculation tab

Once you have those two pieces fixed, I think you still have a problem. And I
bet it's because the ID isn't the same in A2 and in column A of the CSV file.

Debra Dalgleish has lots of notes on troubleshooting =vlookup():
http://contextures.com/xlFunctions02.html#Trouble
 

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

Top