Vlookup problem

[Amyb_rude]

Hi,

I'm trying to return a word/string of words using a vlookup and its just not happening.

Both table arrays are in the same workbook which i don't think should be causing a problem (?) but I keep getting 'NA' returned.

I'm using the below forumal which i think is right.....?

=VLOOKUP(A2,'Coding Sheet'!$A$1:$G$267,1,false)

Thanks,

Amy

 

[xld]

There doesn't seem to be anything wrong with the formula per se, but may the values in A2 and column A of the other sheet are not exactly the same, maybe one has some trailing spaces or something.

 

[Amyb_rude]

Thanks XLD. I'll check the spacing to see if there are any anomalies, so watch this space. I thought the formula was right....got so frustrating!

Thanks again.

 

[Peter_SSs]

Could it be that you think you have numbers in column A of both sheets when in fact one column A is numeric and the other column A is text?



Secondly,
=VLOOKUP(A2,'Coding Sheet'!$A$1:$G$267,1,false)
why use columns A:G in the lookup sheet if you are only returning the value from column A (col 1) anyway? As it stands, your formula appears to simply check if A2 is in A1:A267 of 'Coding Sheet' and if it is, return the same value, otherwise return #N/A

 

[Amyb_rude]

Hi Peter,

The values in Column A (sheet 2) were numeric and not alpha so i just swapped them over and now my vlookup is working!!

Thanks for your help.