THANK YOU THANK YOU THANK YOU!!!! I've never even heard of that 'text'
formula! I love this site~!!!

"Stefi" wrote:

Sometimes - especially with imported data - simple reformatting doesn't help.
E.g. if you want to create a real Excel text string, reformatting cells like
text doesn't do it. You have to use =TEXT(A1,"@") function to convert the
original value.

But we can give you more help if you post your data layout.

Regards,
Stefi


€žMindy€� ezt Ã*rta:

I am having the exact problem. I have sorted, formatted, double checked
everything--can see the result is there, but it will not pull in. This is
very frustrating. In the meantime, I have to put the data in manually.

"SJayTee" wrote:

I have the following formula:

=VLOOKUP(B27,BOM!$A$10:$M$99,13,FALSE)

which is returning an error #N/A.

I know the information is there because I can see it.

I have check and re-checked all of the arguments and can't see what's wrong.

Can anybody help?
--
SJT