How to Skip to Next Cell If a Cell Is Blank in Excel (5 Easy Ways)

If you are looking for ways to skip to the next cell if a cell is blank in Excel, then this article will serve this purpose. So, let’s start with the main article to know more about this task.

How to Skip to Next Cell If a Cell Is Blank in Excel: 5 Ways

Here, we have the following dataset containing a list of Ids, Products, and their corresponding Sales values. In the Product ID column and Product column, we have some blank cells and using some formulas we will skip these blank cells and retrieve values from the next cells.

For completing this article, we have used the Microsoft Excel 365 version, but you can use any other version at your convenience.

Method-1: Using IF Function to Skip to Next Cell If a Cell Is Blank in Excel

In this section, we are going to use the IF function to make a list of products for which they don’t have corresponding Product IDs. So, when we don’t have values in a cell of the Product ID column, then we are moving to the adjacent cell and then extract the values in the List column.

Steps:

• Type the following formula in cell E4.

Here, B4 is the Product ID, and C4 is the corresponding Product name. If cell B4 is blank, then it returns the product name Apple, otherwise a blank.

• Press ENTER and drag down the Fill Handle.

Finally, we are having the following results in the List column.

Read More: How to Skip Blank Rows Using Formula in Excel

Method-2: Using IF and ISBLANK Functions

Here, we will combine the name of the products which don’t have corresponding Product IDs in the List column using the combination of the IF and ISBLANK functions.

Steps:

• Type the following formula in cell E4.

Here, B4 is the Product ID, and C4 is the corresponding Product name. If cell B4 is blank, then it returns the product name Apple, otherwise a blank.

• Press ENTER and drag down the Fill Handle.

In this way, you will have a list of names of products without ids and we have extracted these names by skipping the blank cells of the Product ID column to the next cells of the Product column.

Read More: How to Skip a Column When Selecting in Excel

Method-3: Implementing IFS Function to Skip to Next Cell If a Cell Is Blank in Excel

In this section, we will skip the blank cells of the Product ID column and move to the next cell of the Product column to extract the name of the products and then gather them in the List column. For this purpose, here we will be using the IF, ISNA, and IFS functions.

Steps:

• Apply the following formula in cell E4.

Here, B4 is the Product ID, and C4 is the corresponding Product name.

• Press ENTER and drag down the Fill Handle.

Eventually, you will get a list of products without Product Ids in the List column.

Read More: How to Skip Every Other Column Using Excel Formula

Method-4: Using a Combination of IFERROR, VLOOKUP, IF Functions

Here, we will search for the sales values in the Sales column, and then using the IFERROR, VLOOKUP, and IF functions we will skip the blank cells of the Product column and then move to the Sales column to extract the corresponding sales values.

In the following datasheet in a new sheet, we will extract the values in the Sales column.

Steps:

• Apply the following formula in cell C4.

Here, B4 is the Product ID.

• Press ENTER and drag down the Fill Handle.

Finally, we are getting the sales values for the blank products in the Sales column of the new sheet.

Read More: Skip to Next Result with VLOOKUP If Blank Cell Is Present

Method-5: Applying IF and XLOOKUP Functions to Skip to Next Cell If a Cell Is Blank in Excel

In this step, we are going to apply the combination of the IF and XLOOKUP functions to get a product name for a blank cell of the Product column and the returned name of the products will be prior to the blank cell. Finally, we will filter these values with the help of the FILTER function.

Steps:

• First, keep the initial cell of the List column as Blank.

• Insert the following formula in cell D5.

=IF(B5=””,IF(B5=””,XLOOKUP(“*”,$B$4:B5,$B$4:B5,””,2,-1),””),IF(B5<>””,””,IF(D4=””,””,B5)))

• Press ENTER and drag down the Fill Handle.

Finally, we are having the product names for blank cells of this column with names precedent of these blanks.

Ultimately, you can use the following formula to put the names together and remove the spaces.

Here, D4:D11 is the range on which we will be filtering the blanks.

Read More: How to Skip Columns in Excel Formula

Practice Section

For doing practice, we have added a Practice portion on each sheet on the right portion.

Download Practice Workbook

Conclusion

In this article, we tried to show the ways to skip to the next cell if a cell is blank in Excel. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

Related Articles

• Excel Formula to Skip Rows Based on Value
• How to Skip Hidden Cells When Pasting in Excel 
• Skip Cells When Dragging in Excel
• How to Skip Cells in Excel Formula
• How to Skip Lines in Excel

<< Go Back to Skip Cells  | Excel Cells | Learn Excel