Hi,
I've been googling this one but struggling. I have the following formula that if 'no data' is found, I want to cell to remain blank. Right now, it adds a zero and I can't figure out how to avoid that. I know there are conditional formatting methods but these fields are used for other purposes. Thank you!
=IFERROR(VLOOKUP([@[LeanIX ID]],LeanIXData!A:ZZ,MATCH(E$3,LeanIXData!$2:$2,0),0),"")
Bookmarks