Hey guys really need help with this and not able get a response,This formula is working in google sheets but will not work in excel for some reason =IFERROR(INDEX(Sheet3!A:A,SMALL(IF(Sheet3!A2:A$566<>"",ROW(Sheet3!A2:A$566)),ROWS(C$30:C30))),"") I am trying to pull from a list with blank spaces in it and make it one complete list. When I put it in excel it doesnt pull anything....