Can't Explain N/A in Vlookup

[andrew.luke]

Hi, I'm getting the #N/A error when doing Vlookups and don't know why.

Briefly:

1. I know the Vlookup value matches between tables by using the MATCH function
(Before this, I used the TRIM function on the relevant columns and then did paste special values to make sure spaces weren't throwing anything off)

2. I know there are no duplicates

3. The columns and Vlookup values are formatted as text. He attached file is formatted as number though.

4. I know it's not the column number---I tried every possible number in the Vlookup value

5. I know it's not relative vs. Absolute references--I tried them both.

I can't attach the original file since it contains confidential information. So, I replaced the cell values with random numbers. I did paste special values for the columns I wished to match on both tables and then highlighted them in yellow.

I'm totally stumped. So, I'd really appreciate any help someone could offer me.

 

[andrew.luke]

Sorry, I thought I could attach a file. It doesn't appear that I can. However, here is a link: https://drive.google.com/a/state.co.us/file/d/0B5OIB2ro84gzbjh1TXM4NUtUZ2M/view?usp=sharing

 

[Claus Busch]

Hi Andrew,

Am Thu, 16 Oct 2014 09:21:51 -0700 (PDT) schrieb
(e-mail address removed):

Sorry, I thought I could attach a file. It doesn't appear that I can. However, here is a link: https://drive.google.com/a/state.co.us/file/d/0B5OIB2ro84gzbjh1TXM4NUtUZ2M/view?usp=sharing

if you are lookin for a value in column D, column D has to be the first
column in lookup range.
Try:
=VLOOKUP(F4, 'For Vlookup'!$D$2:$I$892,4, FALSE)


Regards
Claus B.