# VLOOKUP wont work not working correctly

December 21, 2012 at 07:10:04
Specs: Windows 7

 Please HELP Ive got a Vlookup buts its not seeing all the data correctly and I cant work out why.Although I can there should be a match is comes up error Hash N/A

See More: VLOOKUP wont work not working correctly

#1
December 21, 2012 at 08:19:56

 This may help: http://blogs.office.com/b/microsoft...

#2
December 21, 2012 at 08:33:43

 Without seeing your data and formula, we can't offer too much more than phil22 has offered.As noted at that website, #N/A can often be the result of data that you think matches but in reality doesn't.One quick way to check is to visually find what you think is a match and use a simple formula to see if they really do match.e.g. With your lookup value in A1 and your "visual match" in C11, enter this formula in any cell:=A1=C11If the formula returns TRUE, then it is an exact match and you should look at your VLOOKUP formula. If the formula returns FALSE, then it is not an exact match.There could be a space, a hidden character, etc.As I said, without more information we can't offer anything more specific.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

#3
December 22, 2012 at 10:41:55

 Thanks yes I found ' infront of some of the email adress's so I used CLEAN and TRIM

Related Solutions

#4
December 22, 2012 at 10:43:51

 Good site Thanks

#5
December 22, 2012 at 15:54:25

#6
December 23, 2012 at 07:30:10

 Further to Vlookup explanations I dont seem to be getting it =VLOOKUP(A5,New_keep_fmt!A5:B32,10) I have emory_Cossins@hotmail.com in A5 and this also appears within the range A5:B32 I thought it looked along the line until column 10 and returned the value How do I get it to look along the line when it finds emory_cossins@hotmail.com and return his 1st Name and then Suname in Column Y&AAMany many thanks