+ Reply to Thread
Results 1 to 2 of 2

Finding the different the Unit of Measures in cells with text and return a "D" or "L"

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Gainesville, FL
    MS-Off Ver
    Microsoft 365
    Posts
    69

    Finding the different the Unit of Measures in cells with text and return a "D" or "L"

    All, Good Afternoon.
    I am trying to wrap a project up currently and have one final question for the attached spreadsheet.

    Object is to find a formula that will look at the Description Column (A2:A18) for a specific Unit of Measure that is present in the Column B.

    I want to return the letter "D" or "L".

    In adddition, One issue I have is in Cell B3 and Cell B8 is that both contain the lookup UOM of "oz". B3 should return a "D" in Cell D3.... and B8 should return a "L" in cell D8. I am not sure how to differentiate this.

    My intention is to have one formula that I can spill down to get the correct letter in all cells below.

    This speadsheet I am working on is appx 3000 rows. So one formula would be great. Any help with this is really really appreciated. Thank you in advance.

    Pete
    Attached Files Attached Files

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,682

    Re: Finding the different the Unit of Measures in cells with text and return a "D" or "L"

    I suggest that you create a look up table that contains all your Units of Measure and whether it is liquid or dry. Then you can use Vlookup or Index/Match to complete your task.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  2. Replies: 12
    Last Post: 06-12-2014, 02:11 PM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  5. [SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix
    By bertrand82 in forum Excel General
    Replies: 11
    Last Post: 04-30-2012, 09:20 AM
  6. Replies: 3
    Last Post: 02-16-2011, 02:55 PM
  7. Replies: 4
    Last Post: 01-21-2008, 08:22 AM

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