I have a new sheet where I want to summarise all jobs which have a certain status from another sheet. I have all my data in JobTable on Jobs sheet and am using the following which doesn't work:-
=IF(JobTable[Current Job Status]="OFFICE",JobTable[Job No],"")
I want a list of job numbers which have the status of OFFICE displayed. I can see how the above formula doesn't work but can't see why - it seems such a simple thing to do but I'm having a brain freeze!
I'm thinking it needs to use INDEX in there somewhere.
Bookmarks