Results 1 to 4 of 4

Match Header to show yes or no in cell`

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2012
    Location
    PLYMOUTH ,MI
    MS-Off Ver
    Excel 365
    Posts
    114

    Match Header to show yes or no in cell`

    Good afternoon all,
    Not sure how well im going to explain this,
    I have 2 sheets on this workbook, and im trying to show a "Yes" or "No" value to show if my listing is active on a marketplace. I know i could use a pivot table but I dont want to for certain reasons as this sheet may grow larger over the next few weeks wit hmore data.

    On sheet 1, I have my header info with the marketplaces and on sheet 2 I have the SKUs and marketplaces the SKU is listed on.

    I would like to place a "yes" or "no" in the cell to match SKU and marketplace if there is a listing or not.

    I cant figure out the match formula for this. Any help is greatly appreciated

    See attached for the example

    Thank you for your time
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to deduct values under a header from another cell and show it in different cell
    By me_shubham2612 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2019, 08:51 AM
  2. Replies: 5
    Last Post: 03-19-2019, 11:41 AM
  3. Helped needed to index match row header, column header, and sheet
    By vw103604 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2016, 12:37 PM
  4. Match list name of header and find blanks cell in row
    By shrinivasmj in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-22-2012, 11:38 PM
  5. Header to Match Worksheet Cell or Cells?
    By mycon73 in forum Excel General
    Replies: 2
    Last Post: 03-03-2011, 09:48 PM
  6. [SOLVED] Show header in cell
    By Darrin in forum Excel General
    Replies: 3
    Last Post: 06-22-2005, 02: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