+ Reply to Thread
Results 1 to 7 of 7

Trouble Shooting formulas #REF #VALUE

  1. #1
    Forum Contributor
    Join Date
    06-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    114

    Trouble Shooting formulas #REF #VALUE

    Cannot seem to get this formula working

    Its in tab "turbo lister" in column I and column P

    Turbo Lister.xlsx
    Last edited by king10001; 08-29-2013 at 06:19 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Trouble Shooting formulas #REF #VALUE

    Navigate to Conditional formatting > New rule > 'Use a formula to determine which cell to format'

    Paste this function.

    =ISERROR(A2)
    Attached Files Attached Files
    Last edited by ramananhrm; 08-29-2013 at 06:13 AM.
    Please click 'Add reputation', if my answer helped you.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Trouble Shooting formulas #REF #VALUE

    Make Use of Iferror() function

    Something like this...
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Trouble Shooting formulas #REF #VALUE

    Do you mean in I2 and copy down?

    =VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Forum Contributor
    Join Date
    06-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    114

    Re: Trouble Shooting formulas #REF #VALUE

    Quote Originally Posted by Fotis1991 View Post
    Do you mean in I2 and copy down?

    =VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)
    Simples, been looking at this sheet for ages and it was a simple fix.

  6. #6
    Forum Contributor
    Join Date
    06-24-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 365
    Posts
    114

    Re: [SOLVED]Trouble Shooting formulas #REF #VALUE

    Fotis

    If with that Formula I wanted to it to lookup and if no value found to change cell to 77, how would that be done.

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Trouble Shooting formulas #REF #VALUE

    Do you mean?

    =iferror(VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0),77) for excel > 2003

    OR

    =IF(ISERROR(VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)),77,VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0))

    for excel <2007

+ 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. [SOLVED] sum formula trouble shooting
    By kurl01 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-03-2013, 07:43 AM
  2. Trouble Shooting VBA Vlookup
    By Decoderman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-14-2011, 12:28 PM
  3. Trouble Shooting SumProduct Formula
    By rgold in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2009, 01:42 PM
  4. [SOLVED] Trouble shooting Excel?
    By meersr in forum Excel General
    Replies: 1
    Last Post: 04-15-2006, 03:15 PM
  5. trouble shooting section
    By danielle in forum Excel General
    Replies: 1
    Last Post: 04-25-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1