Hello,
I'm using a vlookup formula and want it to return an absolute value, but I can't seem to get the formula right. any ideas???
Try wrapping the VLOOKUP in ABS, something like this
=ABS(VLOOKUP(A1,B2:C3,2,0))
clearly the VLOOKUP must return a number
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks