Results 1 to 4 of 4

Lookup last text from the column or row but exclude certain words

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2021
    Location
    Finland
    MS-Off Ver
    Version 2305 (Build 16501.20196)
    Posts
    6

    Lookup last text from the column or row but exclude certain words

    Hello,

    This is probably easy but I can't still figure it out.

    I wan't to lookup (or use other similar method) the last text or value from a column or row. For this, there is a function like =LOOKUP(2,1/(B3:I3<>""),B3:I3). But how do I exclude two different words for the search?

    For example, I want the last word from the row to be displayed in column J so that it is not dog OR cat (basically the ones highlighted in green should be displayed).

    Any ideas?

    Thanks in advance.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate Rows of text but exclude specific words
    By Mr_SIP in forum Excel General
    Replies: 4
    Last Post: 02-07-2023, 07:40 AM
  2. [SOLVED] Given If any words in column A match any string of text in column B, return column B
    By dbmoney123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-02-2022, 10:55 AM
  3. VBA Lookup Words in column Return multiple results from list
    By zombie1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-20-2021, 09:57 AM
  4. Replies: 4
    Last Post: 03-04-2020, 01:04 PM
  5. Exclude some words from CheckSpelling
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-17-2018, 11:08 PM
  6. Exclude words from a formula
    By daniel.thomas10 in forum Excel General
    Replies: 2
    Last Post: 11-22-2010, 03:31 PM
  7. Sort and exclude certain words
    By jds217 in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 08:40 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