Results 1 to 2 of 2

Thread: Multiple Entries to find text within cell and return value from another table!

  1. #1

    Multiple Entries to find text within cell and return value from another table!



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have 100 entries of text which often differs by character or case. I am trying to somehow find the word in the text and use a formula somehow use a formula or macro, similar to a v lookup, which will return the corresponding number from a table. For example, as seen below, I would want to return pear from the text and then somehow return the number 3 from the table below it. I am unsure how to do this. Please help!

    Text
    AN APPLE
    apple 24586
    fdi banana
    pear ghr
    (a) pear

    Fruit Number
    Apple 1
    Banana 2
    Pear 3

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    pl find attachment. is this help you ?
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •