Results 1 to 6 of 6

Formula to extract values

Threaded View

  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    Norway, Ålesund
    MS-Off Ver
    Microsoft office 2010/2013
    Posts
    51

    Formula to extract values

    Hey, so what I want to do, is to make a formula in the cells marked with yellow that can find the values posted in sheet2 (The values in sheet 2 will be hard coded). For example, “items” (Test1, test1 etc.) in column B has a corresponding value in column F and for Column C it is corresponding with column G. I want to be able to get the values in sheet2 to sheet1 and be able to them in sheet 1 without gaps between the values (Blank rows).

    TL;DR want to make a formula in sheet1 to get the values in yellow background(Which are from sheet2)
    Attached Files Attached Files
    Last edited by Buster^; 06-20-2014 at 10:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help making a macro to copy range of values based on cell values.
    By zolton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2013, 08:58 AM
  2. Making negative values equal 0
    By resdin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2012, 05:03 PM
  3. Formula for Ignore Hide Values while making SUM ?
    By VICTOR5 in forum Excel General
    Replies: 3
    Last Post: 09-27-2011, 08:34 AM
  4. Making cell values correspond with Drop down List values
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2008, 03:14 AM
  5. making hidden values appear
    By lonk61524 in forum Excel General
    Replies: 8
    Last Post: 09-17-2007, 08:05 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