Forum Discussion

shannonholmes's avatar
shannonholmes
Copper Contributor
Apr 12, 2021
Solved

Checking multiple cells, skipping if blank and returning the value of the cell once it is found

I have tried all sorts of fomula's and the current version that I have is  =IF(LEN(VLOOKUP(A2, inventory!A:E, 3, FALSE))=0,VLOOKUP(A2, inventory!A:E, 3, FALSE), VLOOKUP(A2, inventory!A:E, 4, FALSE))...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 13, 2021

    shannonholmes 

    Try this then:

     

    =IFERROR(IF(VLOOKUP(A3,Inventory!A:E,3,FALSE)&""="",IF(VLOOKUP(A3,Inventory!A:E,4,FALSE)&""="",IF(VLOOKUP(A3,Inventory!A:E,5,FALSE)&""="","",VLOOKUP(A3,Inventory!A:E,5,FALSE)),VLOOKUP(A3,Inventory!A:E,4,FALSE)),VLOOKUP(A3,Inventory!A:E,3,FALSE)),"")

Anique-Azhar-985's avatar
Anique-Azhar-985
Copper Contributor
Feb 08, 2025

"To resolve the issue you're facing with checking multiple columns for values in your VLOOKUP formula, you might want to try using the IFERROR function to handle missing values. Here's an improved version of your formula:

=IFERROR(VLOOKUP(A3, inventory!A:E, 3, FALSE), IFERROR(VLOOKUP(A3, inventory!A:E, 4, FALSE), VLOOKUP(A3, inventory!A:E, 5, FALSE)))

This checks the columns one by one, skipping if the cell is blank or returns an error, and stops once it finds a value.

Also, if you're looking for some comfort food ideas while working on your Excel sheet, check out https://portillos-menu.com/ for some delicious options!"

Resources