Thread: [Solved] Not showing Result
View Single Post
 
Old 07-18-2022, 02:25 PM
justa_guy_32405 justa_guy_32405 is offline Windows 7 64bit Office 2010
Novice
  
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default I you have a minute.. same subject, a reference lookup
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?
Last edited by justa_guy_32405; 07-18-2022 at 07:03 PM. Reason: Add file
Reply With Quote