+ Reply to Thread
Results 1 to 13 of 13

Formula tells me to use VLOOKUP and a function that looks up the tour code

  1. 02-15-2015, 09:29 PM #1
    mspad33
    mspad33 is offline
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Unhappy Formula tells me to use VLOOKUP and a function that looks up the tour code

    I've tried to figure out the tour code for this problem for over an hour now but can not seem to get/find it.
    The rest of the formula is =VLOOKUP(tourcode,tours,2,FALSE)

    This is the problem
    Click cell D13 on the Data sheet and insert a VLOOKUP function that looks up the tour code, compares it to the tours table, and returns the description. Copy the function down through cell D22.

    If anyone could help me out with this function I would greatly appreciate it!
    Reply With QuoteRegister To Reply
  2. 02-15-2015, 09:32 PM #2
    mspad33
    mspad33 is offline
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Here is the sheet attached:e00a1Trips_LastFirst.xlsx
    Reply With QuoteRegister To Reply
  3. 02-15-2015, 09:33 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    This sounds like a homework assignment?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 02-15-2015, 09:37 PM #4
    mspad33
    mspad33 is offline
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    It is, I am having trouble on this question. Is there any way you can help me figure out the tour code?
    Reply With QuoteRegister To Reply
  5. 02-15-2015, 09:38 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Looking at your file, have you tried putting that formula on Data sheet D13?
    Reply With QuoteRegister To Reply
  6. 02-15-2015, 09:40 PM #6
    mspad33
    mspad33 is offline
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Yes, I have and it says #N/A
    Reply With QuoteRegister To Reply
  7. 02-15-2015, 09:46 PM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Seemed to work OK for me

    A
    B
    C
    D
    12
    Agent Name
    Student ID
    Tour Code
    Trip Description
    13
    		 Avery
    10001
    20
    		 Check Out the Czech Republic!
    14
    		 Collins
    10002
    30
    		 Croatian Wonders
    15
    		 Avery
    10003
    10
    		 Adventures in Canada
    16
    		 McDonnough
    10004
    50
    		 Parisian Pleasures


    D13=VLOOKUP(C13,tours,2,FALSE)

    If the file you uploaded is anything to go by, it looks like you put that on sheet Lookup Tables, not Data
    Reply With QuoteRegister To Reply
  8. 02-15-2015, 09:52 PM #8
    mspad33
    mspad33 is offline
    Registered User
    Join Date
    02-08-2015
    Location
    Clinton TWP, MI
    MS-Off Ver
    2007
    Posts
    15

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Thank you so much for your help!
    Reply With QuoteRegister To Reply
  9. 02-15-2015, 10:35 PM #9
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    You didnt really need help, you already had what you needed - just in teh wrong place

    Thanks for the feedback
    Reply With QuoteRegister To Reply
  10. 07-03-2015, 01:15 AM #10
    tiffanyvo
    tiffanyvo is offline
    Registered User
    Join Date
    07-03-2015
    Location
    United States
    MS-Off Ver
    2013
    Posts
    1

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Im trying so many time but its said N/A. Please help
    Reply With QuoteRegister To Reply
  11. 07-03-2015, 01:33 AM #11
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Tiffany, welcome to the forum

    Im not sure what you are trying, and what is not working, but Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Reply With QuoteRegister To Reply
  12. 04-03-2016, 02:50 PM #12
    Notyouraveragej
    Notyouraveragej is offline
    Registered User
    Join Date
    04-03-2016
    Location
    Dallas, Texas
    MS-Off Ver
    13
    Posts
    1

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    Did you complete the assignment?
    Reply With QuoteRegister To Reply
  13. 10-06-2016, 08:42 PM #13
    marketlady
    marketlady is offline
    Registered User
    Join Date
    09-29-2016
    Location
    Birmingham, AL
    MS-Off Ver
    2013
    Posts
    1

    Re: Formula tells me to use VLOOKUP and a function that looks up the tour code

    It keeps giving me #NA or #NAME too.... uggh! So frustrating! I tried both solutions.
    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. formula which tells me when something is due in days
    By s8lly76 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2015, 06:46 AM
  2. Determining the order of a tour
    By sergio91 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2013, 01:39 PM
  3. Need a function that tells me if this # has been used before
    By Shawn4789 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-03-2013, 04:43 PM
  4. [SOLVED] Formula that tells me whether a date is later than the current.
    By VivatMartin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2012, 10:20 AM
  5. Is there a function that tells if text in cell is boldfaced?
    By keybordrfm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-22-2006, 07:50 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