vlookup #NA error

[MASHED_33]

Hi,

I'm getting #NA error in vlookup function, I've already checked spaces in lookup value and ensured that all are in "General" format. formula in #NA value is =VLOOKUP(H4,$C$3:$F$7,3,0)

	C</SPAN>	D</SPAN>	E</SPAN>	F</SPAN>	G</SPAN>	H</SPAN>	I</SPAN>
3</SPAN>	ADAMS HARKNESS HILL INC</SPAN>	0</SPAN>	afisher@DGTI14 </SPAN>	1234</SPAN>
4</SPAN>	ADAMS HARKNESS HILL INC</SPAN>	8813150</SPAN>	afisher0@adamsharkness.com</SPAN>	1234</SPAN>		8813150</SPAN>	#N/A</SPAN>
5</SPAN>	ADAMS HARKNESS HILL INC</SPAN>	0</SPAN>	AFISHERAHH@DGTI14 </SPAN>	1234</SPAN>
6</SPAN>	ADAMS HARKNESS HILL INC</SPAN>	0</SPAN>	AHHADMIN@DGTI14 </SPAN>	1234</SPAN>
7</SPAN>	ADAMS HARKNESS HILL INC</SPAN>	9009310</SPAN>	ahhadmin0@adamsharkness.com</SPAN>	1234</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL span=2><COL><COL></COLGROUP>

Thanks for your help in advance.

 

[Aladin Akyurek]

What is in H4?

 

[MASHED_33]

It's 8813150</SPAN>

 

[Michael M]

Change your formula to

=VLOOKUP(H4,$D$3:$F$7,2,0)

The value you are using to Lookup MUST be in the 1st column of the lookup table

 

[MASHED_33]

Thanks Michael, I'll surely keep that in mind.