Hi guys, 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.