03-08-2021, 11:20 AM
(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[://]www.excel-easy.com/examples/two-column-lookup[.]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....