Flawless! an absolute whiz.. I can't thank you enough! I emailed the solution to the young'n at the desk.. I couldn't put it down this evening myself.. I might actually have a weekend! Is a credit url linking back to your profile here good?

It dawned on me over the weekend that the new functions would be moot because the actual status wouldn't be tracked in the sheet, so multiple copies open and reqs coming in would still leave the possibility of 1 tech getting returned on several instances in a wcs.
I made a new sheet [Status] an exact dup of sheet 2 it will monitor the status of sheet 1 [Assign] and sheet 3 [Tasks].
=IFERROR(VLOOKUP(E1,Tasks!$C$2:$E$14,1,"S"), IFERROR(VLOOKUP(E1,Assign!D6:$D$112,1,"R"), IFERROR(VLOOKUP(E1,Assign!G6:$G$112,1,0),"A")))
I don't get any errors and the wizard shows results in the pointed out spots.
Any clue?

Not that I can see.


By the way;

'tech' = number?
'wcs' = ?

wcs = worst case scenario.. habit.. Yes the tech was the number.. I found the problem.. The column inserted into the status sheet to track the current number value returned in the G column you supplied.. was canceling everything out. Since the task is back to me, I can take a little time and roll the process around my head. It's unlikely any 2 or more people will be entering info at the same exact moment. I might explore a connection to a sql db to connect the web forms and the sheets to, or vb to directly write and read the csv file..