Hello,
Could someone please explain how the if{1,0} works in the formula below and also how the {Comments/remarks,Name,Address,DOB,POB,Nationality,Oracle ID…}2 works ?
I understand that the curly braces are used for arrays...just do not understand how they apply to this formula.
=VLOOKUP(Unique Transaction ID column&Details Required column, if{1,0},Previous Unique Transaction ID column&Previous Details Required column,{Comments/remarks,Name,Address,DOB,POB,Nationality,Oracle ID…}2,0)
Thank you !!
Bookmarks