Forum Discussion

cblabey's avatar
cblabey
Copper Contributor
Feb 15, 2019

Vlookup for when it can't find AND when it's blank

I currently have the following formula set up   =IFERROR(VLOOKUP(C163,Validator!K:L,2,FALSE),"Click to learn more")   That means it looks up text in another table to find a result, and if the tit...
excel
Excel Formula
IF Formula
IFERROR
vlookup
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 15, 2019

Hi,

 

You may wrap your formula like

=IF(ISBLANK(C163),"",IFERROR(VLOOKUP(C163,Validator!K:L,2,FALSE),"Click to learn more"))

 

Resources