Results 1 to 11 of 11

Match values in a different sheet

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    6

    Match values in a different sheet

    [SOLVED] Would anybody please help me create a formula that does the following?

    Sheet #1 contains a list of product names in column A, their SKU’s in column B (alpha numeric codes, for example STAR10) and the number of products sold listed in column C, respectively.

    Sheet #2 row #2 contains the some of the SKU’s listed in Sheet 1 in column B. I would like to create a formula that will be used in Sheet 2, row 3 that:
    - matches the SKU in row 2 with the SKU in column B in worksheet 1, then
    - looks up the value in column C (number of items sold)
    - returns that value increased by 20%
    - rounded up to 2 decimal places to the left of the decimal
    - if a match is not found should return 0

    Is this possible because after a few good hours of failed attempts I am ready to give up?
    :-)

    Thank you
    Last edited by FDibbins; 10-26-2012 at 08:52 PM.

Thread Information

Users Browsing this Thread

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

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