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.
Bookmarks