Results 1 to 4 of 4

Search Row for Value and Return the Next Cell Value

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2009
    Location
    Eagan, MN
    MS-Off Ver
    Excel 365
    Posts
    59

    Search Row for Value and Return the Next Cell Value

    I have a worksheet with thousands of rows of data, and I need to extract the UPC number from that row into the column labeled UPC, highlighted in yellow, at the end of that row. The UPC number is in the cell next to the cell that says UPC, in some cases there is no UPC number, and the cell will be filled with text for the next item. In that case if there is no number, I would like the value to be blank.
    Attached Files Attached Files
    Last edited by MSchibs; 04-19-2024 at 01:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Search Nth Cell and Return Value
    By richardking in forum Excel General
    Replies: 5
    Last Post: 07-04-2018, 08:28 AM
  2. Replies: 2
    Last Post: 06-15-2018, 11:03 AM
  3. [SOLVED] Search for a name and return the value of a given cell
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-18-2014, 12:06 PM
  4. Search multiple worksheets for matching cell value and return cell location as a hyperlink
    By wickedsparrow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2013, 08:47 PM
  5. Replies: 2
    Last Post: 06-29-2012, 07:02 AM
  6. Replies: 4
    Last Post: 05-12-2011, 02:25 PM
  7. Replies: 1
    Last Post: 01-25-2011, 10:50 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