VLookup

[jvillar3]

I'm trying to link two worksheets using the vlookup function, but I'
receiving several #value errors. I've tested the link and vlooku
function using other identical worksheets, and everything is OK

 

[Vito]

Are the formats for your lookup value and your lookup table the same?
They should be for Vlookup to work properly

 

[jvillar3]

The formatting is the same for the both spreadsheets. I've also checke
for any spaces or returns. thanks

 

[Niek Otten]

Use ISNUMBER() or ISTEXT for both series to make sure there is no text which
looks like numbers but isn't. Formatting will not help.
If there is text which should be numbers, do the following:

Format an empty cell as General. Enter the number 1.
Edit>Copy
Select your "numbers"
Edit>Paste special, check Multiply

Why not post your formula? What is the 4th argument? Is the data sorted?

 

[Vito]

Can you post your formula? And perhaps some sample data from you
tables and your lookup values

 

[jvillar3]

my formula is "=-VLOOKUP($O215,RANGE,2,FALSE)" where $O is a number.
I've verified there is no text, only number. The other thing I'l
mention is that while one row of information, the following row o
information will have #value errors, while the formulas are the same.
I'm sorry but I can provide the data

 

[Dave Peterson]

If you remove the negative symbol, what does your formula return?

=VLOOKUP($O215,RANGE,2,FALSE)

If it returns a string of text (like: ASDF), then -ASDF would cause #value to
occur.

 

[Niek Otten]

Did you test the numbers using ISNUMBER?

 

[Niek Otten]

Both ranges, the ones you use to lookup and the ones you lookup in?
I'm quite sure that is the problem.

 

[jvillar3]

I found my error. The range that I was using for the table_array di
not cover all the data (over 2000 rows). I simply expanded my rang
and it took care of everything. Thanks to al

 

[Niek Otten]

Congratulations!

Don't hesitate to post again if you have an Excel problem, but please try to
be a bit more informative. We more or less had to drag the information out
of you.