Results 1 to 15 of 15

Pulling data from a cell.

Threaded View

  1. 08-02-2015, 11:04 PM #14
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Pulling data from a cell.

    Try this formula which will add "-" to the negative number.

    =IFERROR(LOOKUP(10^308,--MID(B1,FIND("price",B1,FIND("price",B1)+4)+8,ROW(B$1:B$99))),"")
    Last edited by AlKey; 08-02-2015 at 11:30 PM.
    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. Pulling row data by cell text
    By tanelli80 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-17-2013, 03:32 PM
  2. Pulling text data and dollar amount data from same cell
    By micadeli in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2013, 11:21 AM
  3. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  4. Pulling data from moving cell
    By jaikin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2009, 10:31 AM
  5. Pulling data from a cell as a variable
    By ste_mulv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 11:48 AM
  6. Pulling data from a cell location based upon two inputs /axis choices in a data table
    By ChristopherK in forum Excel General
    Replies: 2
    Last Post: 02-27-2009, 02:01 PM
  7. [SOLVED] Pulling some data from cell?
    By tr2usa@yahoo.com in forum Excel General
    Replies: 7
    Last Post: 01-03-2006, 05:45 PM
  8. [SOLVED] pulling certain data out of a cell
    By D richardson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2005, 02: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1