This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Extract results with question and guidance
(03-08-2021, 11:15 AM)robvanos Wrote: Hi, that's going to be difficult with the setup of the output sheet as you indicated. The guidance sheet does have an identifier, but if you want to use a lookup formula (VLOOKUP) you would have to put the identifier in column A for all values. Essentially, this is even a double lookup function, so you'd have to use something as described in https[://][.]html. And even then, you'd still have to copy the questions into a single sheet. You could use a cell copy function (press '=' and select the cell from the other sheets ou wish to copy, and then drag down and correct where necessary) to make it a little faster.

It's clear though, that the tool was not designed with this in mind.

No Problemo, Rob, Thought I ask. Am so itching to make a web form out of this....

Messages In This Thread
RE: Extract results with question and guidance - by Keoxes - 03-08-2021, 11:20 AM

Forum Jump:

Users browsing this thread: 1 Guest(s)