Tuesday, June 28, 2011

Enhancing your vlookup function

Here's another tip to help enhancing the way how you use your vlookup function by removing the "#N/A" when the unique key isn't available.

We can remedy this by judicious use of Excel’s IF() and ISBLANK() functions. We change our formula from this…
=VLOOKUP(A11,’Product Database’!A2:D7,2,FALSE)
…to this…
=IF(ISBLANK(A11),”",VLOOKUP(A11,’Product Database’!A2:D7,2,FALSE))