Results 1 to 6 of 6

Vlookup formula does not work correctly

Threaded View

  1. 04-12-2018, 08:02 PM #1
    Reykjavik
    Reykjavik is offline
    Forum Contributor
    Join Date
    08-26-2009
    Location
    Iceland
    MS-Off Ver
    Excel 365, Windows 10
    Posts
    110

    Vlookup formula does not work correctly

    I am distributed salary to several dimensions, to find out cost by tasks.

    I am try to split dimension f.x 10203040 in 10 20 30 40 where first set of number is for group A of tasks, next two for group B of tasks etc.
    I use left, and mid to split.

    Next I want to use vlookup to make my pivot more readable change first set of number (10) to name (Group1)
    I get #N/A

    Any suggestions to solve it?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula doesn't work correctly
    By Chris McGlothen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2016, 07:28 PM
  2. vlookup and Sum in same formula not working correctly
    By mrichard in forum Excel General
    Replies: 5
    Last Post: 08-31-2015, 08:18 PM
  3. please help with IFERROR - Solved
    By urak in forum Excel General
    Replies: 4
    Last Post: 08-09-2012, 06:28 AM
  4. Need help on Logic to make formula work correctly
    By cdotyii in forum Excel General
    Replies: 1
    Last Post: 06-06-2012, 08:23 AM
  5. Excel 2007 : Vlookup formula does not copy correctly
    By Rahul Orezzoli in forum Excel General
    Replies: 3
    Last Post: 11-17-2011, 01:39 AM
  6. Help Please. Trying to get this formula to work out correctly.
    By bryanr72 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2008, 10:43 PM
  7. dates do not work correctly
    By edhinfla in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-13-2007, 04:43 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1