Results 1 to 2 of 2

Thread: Using a Vlookup to populate a help cell

  1. #1

    Using a Vlookup to populate a help cell



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

    Hi, I have been struggling for several days now to generate the correct formula for my spreadsheet.

    Basically I am looking to add a help/information cell onto my spreadsheet so that when the user fills the sheet in they can refer to the help/information. This cell needs to change each time a new entry is selected in a particular column.

    My sheet is for an expenses form I currently have a vlookup formular returning the help information to the correct cell but I want this to change when I select a new expense in the second row, then 3rd row etc.

    Thanks In advance and please advise if I need to add any additional information.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Have you considered using tool-tips/input messages (part of Excel's data validation functionality). Check out http://www.contextures.com/excel-vid...s.html#message

    Failing that, suggest you upload a sample workbook so we can get a better idea of what you have tried, and what you need.
    Regards

    Jeff

Posting Permissions

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