Results 1 to 2 of 2

Formula Issue

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2011
    Location
    Cleveland, OH
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Formula Issue

    Hello everyone. I hope I posted this in the correct forum. Here is my dilemma. I am trying to merge information from two spreadsheets to another for a report for my boss. Basically, what I want to do is as follows: If there is data in cell R2 of the first spreadsheet, I want to take information from cell B2 of the same spreadsheet and populate cell B2 of the new spreadsheet. If I get this formula right, then I can alter it to fit the other cells for the other information I need to include.

    Here is my formula so far:

    =IF('Q:\SHR\InfoShare\Die Shop\Planning\[DIE INVENTORY]CURRENT'!R2)=('Q:\SHR\InfoShare\Die Shop\Planning\[DIE INVENTORY]CURRENT’!)DATA

    The information in the first spreadsheet resides on Q drive, the path to the workbook is listed, the workbook (DIE INVENTORY) and the worksheet name (CURRENT). I think the formula is right to that point, it’s at this point that it breaks down.

    Can anyone help?
    Last edited by CooperGuy; 01-28-2011 at 01:26 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1