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)
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL span=2><COL><COL></COLGROUP>
Thanks for your help in advance.
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.