+ Reply to Thread
Results 1 to 4 of 4

Minor tweaks needed - locking cells, error messages and IF THEN formula

  1. 07-03-2018, 11:10 AM #1
    racheltallentire
    racheltallentire is offline
    Registered User
    Join Date
    04-06-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    9

    Minor tweaks needed - locking cells, error messages and IF THEN formula

    Hi All

    Hope everyone is having a good day

    I've created a document (limited excel skills) but have got to the point where I need help

    I've attached the document and the green comments show where I think i've sorted it

    The red/purple comments are where i'm stuck - i'm looking for info on how it's done - i'v googled but can't get it quite right

    Can anyone help please?

    Thanks in advance

    Rachel
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2018, 11:24 AM #2
    racheltallentire
    racheltallentire is offline
    Registered User
    Join Date
    04-06-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    9

    Re: Minor tweaks needed - locking cells, error messages and IF THEN formula

    ok, so managed to get rid of the "n/a" from column C which is a start

    still seeking help with the other issues
    Reply With QuoteRegister To Reply
  3. 07-03-2018, 11:30 AM #3
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Minor tweaks needed - locking cells, error messages and IF THEN formula

    You havent said how you did that.

    in C12
    =IFERROR(VLOOKUP(B12,Hidden!C$2:D$7,2,FALSE),"")
    and copy down
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  4. 07-03-2018, 01:29 PM #4
    racheltallentire
    racheltallentire is offline
    Registered User
    Join Date
    04-06-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    9

    Re: Minor tweaks needed - locking cells, error messages and IF THEN formula

    Thanks Special K, that's fab.

    Any advice on area of the other queries by any chance? :D
    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. [SOLVED] Minor tweak to VBA code needed
    By jkilday4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 09:37 AM
  2. [SOLVED] Desperate Help needed with Locking out a range of cells based on selection from 1 cell
    By Vcummi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-31-2012, 04:12 PM
  3. Two cells which have formulas stopping error messages show an error when added !
    By Gooford in forum Excel General
    Replies: 5
    Last Post: 11-10-2009, 07:06 AM
  4. Conditional Locking of Cells- More than one Sub needed?
    By kellyfspringer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2009, 09:21 PM
  5. trying to get rid of formula error messages
    By turbo90talon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-20-2007, 12:31 AM
  6. Locking cells unless needed
    By jimmisavage in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2007, 07:17 AM
  7. [SOLVED] locking formula in cells in without locking whole sheet
    By SuziQ in forum Excel General
    Replies: 1
    Last Post: 07-21-2006, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1