+ Reply to Thread
Results 1 to 2 of 2

Searching column A for text that is in f6 and if it find the text it gives us the data in

  1. 08-03-2017, 05:47 PM #1
    jphilipson
    jphilipson is offline
    Registered User
    Join Date
    08-24-2016
    Location
    California
    MS-Off Ver
    Office 2021
    Posts
    93

    Searching column A for text that is in f6 and if it find the text it gives us the data in

    Hey Guys I have a vlookup formula =VLOOKUP("f6", 'Alpha Prefix Companies'!A:A, 2, FALSE) I want to return the value in column B.
    Reply With QuoteRegister To Reply
  2. 08-03-2017, 05:52 PM #2
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Searching column A for text that is in f6 and if it find the text it gives us the data

    =VLOOKUP("f6", 'Alpha Prefix Companies'!A:B, 2, FALSE)
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    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. [SOLVED] VBA Macro to find text string in one column and replace specific text in another column if
    By bmahfood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2017, 11:15 AM
  2. [SOLVED] How to find text then select RANGE form the text found to lastrow of Column J
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 02:45 AM
  3. [SOLVED] Search through columns and find specific text and replace that text with header column
    By adamzee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-09-2014, 11:59 PM
  4. Searching a text in a column
    By a2zanup in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2014, 03:00 AM
  5. [SOLVED] Searching a column for text (any text) and if it's there place it in a specific cell
    By Gherkin in forum Excel General
    Replies: 19
    Last Post: 04-10-2013, 08:30 AM
  6. Find part of a text in a column and give as a result the position of the text
    By enitron in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 04:33 AM
  7. Help Searching a database to find text that was input
    By jchapm123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-28-2010, 01:59 PM

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