Formula issue not displaying correct information

[topswim]

Morning,

I have formulas that I am using for an array. The issue I am having is not receiving correct results. example vlookup:

=VLOOKUP($H2,$A$2:$D$3000,2), I then drag it down the column, but get back repeated same results or #N?Athen switches to another repeated results. I do not know why it is repeating or not recognizing things at all. I have tried all tips when I researched to try to fix it but nothing. Each cell has something in it so not sure why I'm getting the #N/A. Formula does match up right in what/where it should be pulling from the correct cells as I double check that as well.

 

[Fluff]

Try

=VLOOKUP($H2,$A$2:$D$3000,2,0)

which makes it do an exact match, rather than an approximate match.

 

[queuesmef]

You may need to supply more info. However, based on your limited info, 1. is the lookup range Sorted? 2. is what is being looked up the EXACT same as in the lookup Table (no spaces, punctuation markes etc). Need to find exact match.....Try 'Close match' OR go to a NA cell and find what is should be looking up and compare it to the Lookup Table~ are they an exact match?

 

[Fluff]

is the lookup range Sorted?

Judging by the image, obviously not.