I have an old formula I got off of this forum that I'm trying to modify to look in two different columns.
{=IFERROR(INDEX('IP Scheme'!G:G, SMALL(IF(AND(T_IP_Scheme[Device Type]="Camera",T_IP_Scheme[Service Schedule]="Monthly"), ROW(T_IP_Scheme[Service Schedule])), ROWS(A$2:A2))), "")}
I added the (AND(T_IP_Scheme[Device Type]="Camera",T_IP_Scheme[Service Schedule]="Monthly") part just now and it will not return even though I think I'm using the AND statement properly. It is currently returning 0 with no errors.
If I drop it down to only searching T_IP_Scheme[Device Type]=Camera I get a fully populated list. However we are adding our service plan to the spreadsheet and I now need to sort them by how often we will be servicing said cameras.
Any help would be very appreciated.
Thank you,
Tim Weaver
Bookmarks