Thank you David. That might be the best solution.

My lookup value isn't always column A. What I was hoping for was
something like =column AB-column D. Now I know that won't work but is
there something that will work?

Thanks again,
Shelly


--
shelly2
------------------------------------------------------------------------
shelly2's Profile: http://www.excelforum.com/member.php...o&userid=29852
View this thread: http://www.excelforum.com/showthread...hreadid=495522