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