How to use if (x y z ) formula and vlookup in this node

[johnnybasha]

excel formula to knime
IF(COLUMN_NAME=“080”,COLUMN_NAME,COLUMN_NAME/VLOOKUP(COLUMN_NAME*1, COLUMN_NAME!COLUMN_NAME1: COLUMN _NAME2,3,0))

[ArjenEX]

Hi @johnnybasha

Welcome to the KNIME community!

Please familiarize yourself with the guide on how to write a good post and amend yours accordingly (post body, resources).

How to write a good post

Before we go into this subject: first, and absolutely foremost: always search before posting your question. Your question may have already been posted and answered in the forum. Searching can help you save loads of time and effort! Ok, with that out of the way, let’s go: Writing a good post Let’s say you come to the forums because you need help with an error. Logically, a good title for your post would be “Help with an error”, right? Well…wrong! Put yourself in the shoes of the person browsin…