good day to everyone,

im working on this function
=IF(VLOOKUP(Y4,_CHECKOUTS,1,0)=Y4,"",IFERROR(VLOOKUP(Y4,_CHECKOUTS,1,0),"ED"))

im trying to compare two things, if the number is in list of numbers in _checkouts it will return the number in y4 which this converts to "blank", the second part is if the number is not on the list _checkouts, it returns "ED" but im getting a #n/a

thanks in advance