+ Reply to Thread
Results 1 to 2 of 2

Modifying VLOOKUP formula to include ROUND

  1. #1
    Registered User
    Join Date
    08-26-2004
    Posts
    2

    Question Modifying VLOOKUP formula to include ROUND

    Hello, I'm trying to modify a ton of VLOOKUP formulas to include a round function.

    Currently my formulas look like this:

    (VLOOKUP(EP11,brshare_sort!$A$6:$IM$329,240,FALSE)/brshare_sort!$IF$6)*100

    I want to add the round function to them so they look like this:

    ROUND(((VLOOKUP(EP11,brshare_sort!$A$6:$IM$329,240,FALSE)/brshare_sort!$IF$6)*100),0)

    Is there an automated way to do this? I have a ton of formulas just like this and I'm hoping I don't have to manually go through every formula on the sheet. The problem is that what I try to to global find and replace I get an error b/c I can only put in half of the modification at a time.

    Hope there's a solution out there.

    -- Randy

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    From looking at your formula, it appears all of your lookup and math range references are absolute. You should be able to copy and paste this formula without any trouble. You will need to monitor the reference to your "lookup what" reference to EP11 to ensure you are looking for the right data as you move this formula around.

    If all of your formulas are in column EP, you can just copy down the column.

    HTH
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1