Thanks Benjie,

That fixed my problems.
What was happening was the return value that I was getting was the
value in the last cell of the array. For example:
=VLOOKUP(C697,InventoryCtrl!A2:F175,6) was returning the value in F175
regardless if the lookup value was in the Table Array. When I put the
False in the formula: =VLOOKUP(C697,InventoryCtrl!A2:F175,6,FALSE) it
worked fine. Now it will also work, where it wouldn't be for, just
selecting all the columns: =VLOOKUP(C697,InventoryCtrl!A:F,6,FALSE),
which what I originally wanted.


Thanks Again

tiab86


--
tiab86
------------------------------------------------------------------------
tiab86's Profile: http://www.excelforum.com/member.php...o&userid=25628
View this thread: http://www.excelforum.com/showthread...hreadid=390403