+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP; Looking up value based off of text...

  1. #1
    Registered User
    Join Date
    10-19-2017
    Location
    Raleigh, NC
    MS-Off Ver
    2013
    Posts
    22

    VLOOKUP; Looking up value based off of text...

    I have a spreadsheet where I am trying to use a VLOOKUP formula. My information is spread between multiple sheets - I'm trying to look up information based off of part of a word, am I able to do this (I'd be looking up the first 5 letters of a phrase).
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: VLOOKUP; Looking up value based off of text...

    We really need more information. Where are the VLOOKUP formulae and where are the words you're looking up?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    10-19-2017
    Location
    Raleigh, NC
    MS-Off Ver
    2013
    Posts
    22

    Re: VLOOKUP; Looking up value based off of text...

    Sorry for my incomplete post, I actually figured it out on my own...thanks for the help though, this forum is such a useful tool and so helpful and I keep learning so much!

+ 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. vlookup - based on finding specific text within a cell
    By gromitnz in forum Excel Formulas & Functions
    Replies: 60
    Last Post: 05-16-2016, 06:14 AM
  2. vlookup based on certain text
    By xotrujillo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2016, 06:27 PM
  3. VBA to add text based on vlookup
    By PekkaJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2015, 06:23 PM
  4. VLOOKUP return value based on text in cell
    By Detrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2014, 07:17 PM
  5. VLOOKUP based on cell with specific text
    By hardpenguin in forum Excel General
    Replies: 2
    Last Post: 01-17-2011, 05:33 PM
  6. another vlookup based on text entry
    By MattShoreson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2006, 08:39 AM
  7. VLOOKUP based on PART of another cell's text
    By djDaemon in forum Excel General
    Replies: 0
    Last Post: 03-09-2006, 09:15 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