I have used vlookup on many occasions without any problems, however, to day
for some reason it is not working. Below is the look up range and I want to
return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
ther something I am missing.
92052410035.810
92032200023.410
92042300013.500
92032660023.810
92032820054.660
--
thanks as always for the help
jer
Can you post your formula?quot;jerquot; wrote:
gt; I have used vlookup on many occasions without any problems, however, to day
gt; for some reason it is not working. Below is the look up range and I want to
gt; return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
gt; ther something I am missing.
gt;
gt; 92052410035.810
gt; 92032200023.410
gt; 92042300013.500
gt; 92032660023.810
gt; 92032820054.660
gt;
gt; --
gt; thanks as always for the help
gt; jer
thanks Al, oversight on my part problems sorted out
--
thanks as always for the helpquot;Alquot; wrote:
gt; Can you post your formula?
gt;
gt;
gt; quot;jerquot; wrote:
gt;
gt; gt; I have used vlookup on many occasions without any problems, however, to day
gt; gt; for some reason it is not working. Below is the look up range and I want to
gt; gt; return the value 5.810, 3.410 ... in another table. I am getting N/A# Is
gt; gt; ther something I am missing.
gt; gt;
gt; gt; 92052410035.810
gt; gt; 92032200023.410
gt; gt; 92042300013.500
gt; gt; 92032660023.810
gt; gt; 92032820054.660
gt; gt;
gt; gt; --
gt; gt; thanks as always for the help
gt; gt; jer
- Nov 21 Wed 2007 20:40
problems with vlookup
close
全站熱搜
留言列表
發表留言