# Vlook up to convert negative numbers to positive

#### tinferns

##### Board Regular
Team,
Need your help in correcting the below formula.

So here if the result in Column I3 is negative, I want ABS to convert it to positive.
If the number in I3 is positive, then let it continue the same way - (I3 * 1)

=if(VLOOKUP(G3,Table6[[Refrence]:[Total Pending]],9,0),<0,ABS(i3),(i3*1))

F.Y.I - I will be using this formula on Office 365 and Excel 2019

Thanks,

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### sandy666

##### Banned - Rules violations
maybe enough will be
`=--ABS(VLOOKUP(G3,Table6[[Refrence]:[Total Pending]],9,0))`
and additionally you can use IFERROR()

#### Peter_SSs

##### MrExcel MVP, Moderator
Not a big deal but if sandy666's formula gives you what you want, then so should this which doesn't require the extra two calculations caused by the "--" at the start.

Excel Formula:
``=ABS(VLOOKUP(G3,Table6[[Refrence]:[Total pending]],9,0))``

#### tinferns

##### Board Regular
Thank Sandy666 and Peter SSs.. you guys are awesome.. Thanks a ton...

#### Peter_SSs

##### MrExcel MVP, Moderator
You're welcome. Glad we could help.

#### sandy666

##### Banned - Rules violations
Glad if it works for you

Replies
4
Views
344
Replies
2
Views
152
Replies
8
Views
270
Replies
3
Views
296
Replies
2
Views
262

1,127,208
Messages
5,623,393
Members
415,971
Latest member
gishy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back