Home » Forums » Open Source Learning Center » Question and Answer

VLOOKUP formula

Submitted by Kalop on 9 December, 2012 - 02:13

When using formula [=VLOOKUP(A2,Orders!$H$20:$I$22,2,FALSE)] are situations when the results are FALSE and in output cells is produce FALSE.
How to avoid that, and insted just have empty cells?

‹ conditional formatting with date and time Conditional Formatting and SLA inquiries ›
»

RE: VLOOKUP formula

Submitted by manny on 9 December, 2012 - 14:47.

Hi,

Wrap VLOOKUP with IF function:

 = IF(VLOOKUP(A2, Orders!$H$20:$I$22, 2, FALSE) = FALSE, "", VLOOKUP(A2, Orders!$H$20:$I$22, 2, FALSE))

 

Best regards.

»