+ Reply to Thread
Results 1 to 2 of 2

Vlookup Function

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    9

    Vlookup Function

    Pls help me!
    Is it possible to use the vlookup where my data has a value with a 3 decimal places?

    for Ex. I want to display the result or data on Cell C1 (which computing the Cell B1 and A1) on Cell D1 by using vlookup function on Cell D1 (Matching value of Cell C1 to my Table Array)

    Here it goes..


    Cell
    A1 = (has formula)
    B1 = (has formula)
    C1 = (has also a formula which computing cell B1 and A1)

    *for example let say the ANSWER on Cell C1 is 1.13 (1.125 in 3 decimal places)

    Table Array (in 2 decimal only)

    1.10 =1
    1.11 =1
    1.12 =1
    1.13 = 1.25
    1.14 = 1.25
    115 = 1.25

    Meaning that when my data on C1 is 1.12 the result on Cell D1 will be 1. And that is ok no problem on that. But when the result on C1 is already 3 decimal places of course it will be not matched on my Table Array. That's why I add on my formula a Truncate or Roundup function inside my vlookup (hope I am using the right formula/concept).

    So here are my problem

    1. When I used the Truncate the result were matched on my Table Array but It did not rounded up
    2. But when I used the Roundup it look likes it is not rounded correctly
    3. When the result on Cell C1 is 3 decimal ex 1.125 (1.13 when rounded up) the result should be 1.25 on Cell D1 but it always display 1.

    My other solution was; when i got the result on Cell C1 either 2 or 3 decimal places I rounded first then encode to Cell D1 then my vlookup function will be on Cell E1. And it looks like that It cant help me to simplify my formula.

    Thank you for your help. Hope my explanation is clear :D

    Thank you

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Vlookup Function

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-15-2014, 11:40 PM
  2. Need help nesting an index/match function within a Vlookup function.
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 06:16 PM
  3. Worksheet function Vlookup and VLOOKUP return different results
    By zandero in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2010, 08:24 AM
  4. Replies: 1
    Last Post: 12-02-2005, 09:35 AM
  5. [SOLVED] vlookup function-Can vlookup command find the data from the 5 sheets.
    By Rishab shah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Tags for this Thread

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