Am I correct to assume that you want to lookup the number regardless if it's
positive or negetive? i. e. -1500 then lookup 1500? If so then try:

assuming -1500 is in A1
=VLOOKUP(ABS(A1),CAPACITY,2,1)
or
=VLOOKUP(ABS(A1),CAPACITY,2,0)
depending on your situation.

HTH
JG

"DMB" wrote:

No it shoud have been a phd5.