Is there an ‘If / Then’ formula that can adjust a vlookup’s value?

When I use “VLOOKUP($A43,'Line Items'!$A$2:$M$6000,5,FALSE)” I
sometimes come across a few negative numbers that appear as “ 1000- “.
How can I revise the vlookup formula to ensure that such negative
numbers appear as “ -1000 ”?

Addie


--
addie
------------------------------------------------------------------------
addie's Profile: http://www.excelforum.com/member.php...o&userid=25526
View this thread: http://www.excelforum.com/showthread...hreadid=392498