Results 1 to 6 of 6

[SOLVED] Post a value in a cell based off the value of an index cell?

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    Mesa, AZ
    MS-Off Ver
    2007
    Posts
    3

    [SOLVED] Post a value in a cell based off the value of an index cell?

    I know this is a simply answer but I'm not sure how to set it up, though I'm pretty sure it will be using a VLOOKUP formula. Basically I have a sheet of data that consists of sales, each row containing one sku and the associated costs, etc. that accompany the sale. So basically I am just trying to calculate profit in a given time frame but I need to plug in cost of goods into one of the columns. The cost of each sku I have in another spreadsheet. In the example spreadsheet, how would I get Column K on sheet1 to auto-populate based off the corresponding values in Column B of sheet 2 when Columns B in sheet1 and Column A in sheet 2 match? Example_Book1.xlsx
    Last edited by CPcel; 04-21-2015 at 11:58 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sum/Index based on merged cell data
    By Dulanic in forum Excel General
    Replies: 15
    Last Post: 04-21-2020, 04:22 AM
  2. Post Value Based on several criteria on another cell
    By acerlaptop in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-09-2014, 12:15 AM
  3. index the start of a range based on another cell?
    By tompee29 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-21-2014, 06:00 AM
  4. [SOLVED] Copy top cell post autofilter and re-apply autofilter based on cell value
    By gpato in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2014, 09:07 PM
  5. Submit data to Sheet2 cell based on index value in cell
    By mondo_ray in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2011, 07:57 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