+ Reply to Thread
Results 1 to 4 of 4

Formula Mess

  1. 08-10-2014, 01:26 PM #1
    erikapalen
    erikapalen is offline
    Registered User
    Join Date
    08-07-2014
    Location
    Oregon
    MS-Off Ver
    2010
    Posts
    10

    Formula Mess

    I have a log that other people have access to and someone tried coping over the whole spreadsheet and now the formulas are all messed up. This is what the formula is reading like this in the F column:

    =IF(E35<>"",VLOOKUP(E35,Coding!$A$3:$b$14,2,FALSE),"")

    The E35 column is a List dropdown that has options 1-6 and the F column takes the number we put in E35 and reads the "Coding" tab and enters the corresponding information. However when we enter the 1-6 in E35 the F column doesn’t update. It remains blank.
    Reply With QuoteRegister To Reply
  2. 08-10-2014, 01:31 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,108

    Re: Formula Mess

    Please take a few moments to read the forum rules and change your thread title to something a little less nebulous.

    While you're at it, it would probably help if you could upload a sample workbook.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 08-10-2014, 01:33 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Formula Mess

    deleted forum-induced duplicate thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 08-10-2014, 02:48 PM #4
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,605

    Re: Formula Mess

    Strange - This thread still has 0 replies???
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Dates Mess Up
    By Ramification87 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2010, 08:02 AM
  2. Will moving folders mess up formula?
    By welshman010 in forum Excel General
    Replies: 6
    Last Post: 09-06-2008, 08:04 PM
  3. [SOLVED] Formula Question:don't mess up the math
    By dramajuana in forum Excel General
    Replies: 6
    Last Post: 07-21-2006, 06:50 PM
  4. Is Excel is now going out of it's way to mess me around?
    By Willot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2006, 08:20 PM
  5. Crl-Ed : another way to mess-up and fix
    By Patricia Shannon in forum Excel General
    Replies: 0
    Last Post: 03-23-2006, 02:45 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