+ Reply to Thread
Results 1 to 4 of 4

Formula to search from keyword list and return adjacent cell

  1. 08-31-2013, 08:31 AM #1
    Ninja2k
    Ninja2k is offline
    Registered User
    Join Date
    01-24-2013
    Location
    Ireland
    MS-Off Ver
    Office 2010
    Posts
    34

    Formula to search from keyword list and return adjacent cell

    I have a spreadsheet of data, I need to search the data for keywords and when I find a keyword return its adjacent value.

    My Formulas and Keywords will go on sheet 1 and my data is on sheet Data. I am using Excel 2010

    I need the following logic in a formula
    Read Keywords from B1:B20
    Find keywords on the data sheet A1:A100
    Find a keyword
    Return Adjacent value
    If no keyword is found return blank

    Sheet1
    A1 - Where my formula will go
    B1:B20 - Where my keywords are

    Data
    A1:A100 - List of words
    B1:B100 - List of numbers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-31-2013, 08:39 AM #2
    boopathiraja
    boopathiraja is offline
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Formula to search from keyword list and return adjacent cell

    =IFERROR(VLOOKUP(B2,Data!A2:B100,2,0),"") Drag it down
    ☚ Click ★ just below left if it helps, Boo?ath?
    Reply With QuoteRegister To Reply
  3. 08-31-2013, 08:42 AM #3
    amy_d2
    amy_d2 is offline
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Formula to search from keyword list and return adjacent cell

    you can use this in cell A2 & drag down


    =IFERROR(VLOOKUP(B2,Data!A:B,2,0),"")

    but remove extra space after * in cell B2
    Last edited by amy_d2; 08-31-2013 at 08:44 AM. Reason: forgot about blank condition
    Click on * below if you find this helpful

    Thanks,
    A
    Reply With QuoteRegister To Reply
  4. 08-31-2013, 08:44 AM #4
    Ninja2k
    Ninja2k is offline
    Registered User
    Join Date
    01-24-2013
    Location
    Ireland
    MS-Off Ver
    Office 2010
    Posts
    34

    Re: Formula to search from keyword list and return adjacent cell

    That worked nicely for me, thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search for value in row and return adjacent cell
    By lindseyd32833 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-11-2020, 04:03 PM
  2. Search multiple worksheets for keyword and return all rows with that keyword to new sheet
    By thejesse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  3. Search for value, return value in adjacent cell
    By laerm in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 08-13-2013, 01:12 PM
  4. Re-useability:Search a keyword and copy adjacent cell to in another sheet
    By illustratum in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-21-2013, 06:54 PM
  5. SEARCH MACRO FOR VALUE IN WORKBOOK, RETURN value of adjacent cell.
    By thequiff in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 06-15-2012, 10:47 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1