#N/A is the error value that means “no value is available.” Use NA to mark empty cells.
=IFNA(VLOOKUP(A2,A5:D14,2,FALSE),"") ----->>>>answer is empty
SaeedBaba
I'm an Excel Expert with 10+ of experience, specializing in Excel Worksheets, Advanced Charting, Functions, data visualization, pivot tables, and data analytics. I help businesses to manage projects and analyze data with the use of Excel.