|
|
#21
07-18-2022, 02:25 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul | aligahk06 | Excel | 2 | 09-07-2019 02:23 PM |
| Data Compare and result as true or false in result sheet | aligahk06 | Excel | 1 | 08-29-2019 06:44 AM |
 One Cell that controlls spread sheet result button to change simple fomula result
|
RAH | Excel Programming | 5 | 03-31-2018 04:52 PM |
| Outlook 2013 Gmail IMPA emails not showing dates only showing times | zillah | Outlook | 0 | 12-21-2017 01:20 AM |
| email there but not showing in inbox, notifications showing | bbxrider | Outlook | 0 | 05-15-2017 11:46 PM |
Windows 7 64bit 
Office 2010
Threaded Mode