Jun 11 2019 01:12 PM
Jun 11 2019 01:12 PM
Hi Everyone,
I am new to excel, can you please tell me what kind of this formula? please kindly provide detail how it works? any links for me to learn more about this?
Thank you so much
=IFERROR(IF(Table_Inventory_Items[@[item_2_category_id]]="","",IF(Table_Inventory_Items[@[item_2_category_id]]=Sheet1!A5,"",VLOOKUP(Table_Inventory_Items[@[item_2_category_id]],Table_Inventory_Item_Categories,2,FALSE))),"")
Jun 11 2019 08:17 PM