+ Reply to Thread
Results 1 to 7 of 7

A LOOKUP and INSERT

  1. #1
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    A LOOKUP and INSERT

    Hi. I am developing content for English learners online.

    I am creating a lot of content but sometimes I need to update it, by adding extra info.

    The excel
    Column A: Keyword or expression.
    Column B: A definition
    Column C: I need to insert information
    Column D: The keyword that need to be "looked up" in column A.
    Column E: The text that needs to be inserted in Column C - when keyword match is found.

    I will enclose the excel next.

  2. #2
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: A LOOKUP and INSERT

    Please find enclosed the excel
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: A LOOKUP and INSERT

    C1:

    =IFERROR(VLOOKUP(A1,D:E,2,FALSE),"")

    copy down?

  4. #4
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: A LOOKUP and INSERT

    Hi. Unfortunately, I'm on a macbook and formulas seem to be different. My excel version is 365 - 16.2

  5. #5
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: A LOOKUP and INSERT

    I don't know if there is any chance of you copying and pasting in the excel and sending.

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: A LOOKUP and INSERT

    Here's a file with the formula
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-18-2020
    Location
    Valencia
    MS-Off Ver
    Mac excel - Office 365 - v 16.72
    Posts
    61

    Re: A LOOKUP and INSERT

    That is excellent. Works perfect. Thank you.

+ 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. Lookup & Insert Value in a New Row
    By frank933 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2010, 10:55 AM
  2. Lookup & Insert Value
    By greentea in forum Excel General
    Replies: 6
    Last Post: 02-18-2010, 08:34 PM
  3. Combine, lookup and insert data
    By treva26 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-26-2007, 01:52 AM
  4. Help with Lookup and insert
    By GKS in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-23-2006, 05:34 AM
  5. Insert quotes around a lookup value
    By BabyFade27 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2005, 11:15 PM
  6. RE: Insert quotes around a lookup value
    By bpeltzer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-06-2005, 08:25 PM
  7. [SOLVED] How do I insert a reference to lookup and insert a name
    By Jan K in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-20-2005, 06:05 AM

Tags for this Thread

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