Home

Version of Formula?

%3CLINGO-SUB%20id%3D%22lingo-sub-684821%22%20slang%3D%22en-US%22%3EVersion%20of%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-684821%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20excel%2C%20can%20you%20please%20tell%20me%20what%20kind%20of%20this%20formula%3F%20please%20kindly%20provide%20detail%20how%20it%20works%3F%20any%20links%20for%20me%20to%20learn%20more%20about%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR(IF(Table_Inventory_Items%5B%40%5Bitem_2_category_id%5D%5D%3D%22%22%2C%22%22%2CIF(Table_Inventory_Items%5B%40%5Bitem_2_category_id%5D%5D%3DSheet1!A5%2C%22%22%2CVLOOKUP(Table_Inventory_Items%5B%40%5Bitem_2_category_id%5D%5D%2CTable_Inventory_Item_Categories%2C2%2CFALSE)))%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-684821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-685302%22%20slang%3D%22en-US%22%3ERe%3A%20Version%20of%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685302%22%20slang%3D%22en-US%22%3EThe%20formula%20belongs%20to%20a%20table.%3CBR%20%2F%3EWhen%20you%20see%20%40%2C%20it%20means%20%22look%20at%20the%20value%20in%20the%20same%20row%20where%20the%20formula%20is%2C%20and%20pick%20the%20value%20under%20the%20field%20between%20brackets.%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20table%20named%20Table_Inventory_Items%3CBR%20%2F%3EThe%20formula%20says%3A%3CBR%20%2F%3EIf%20the%20value%20under%20the%20field%20(column)%20%5Bitem_2_category_id%5D%20in%20the%20same%20row%20of%20the%20cell%20containing%20the%20formula%20is%20%22%22%20(empty)%2C%20then%20produce%20%22%22%20(empty)%2C%20otherwise%2C%3CBR%20%2F%3EIf%20that%20same%20value%20under%20%5Bitem_2_category_id%5D%20is%20equal%20to%20the%20value%20in%20cell%20A5%20of%20sheet%201%2C%20then%20produce%20%22%22%20(empty)%20as%20well%2C%20otherwise%3CBR%20%2F%3Elook%20for%20the%20value%20in%20column%20%5Bitem_2_category_id%5D%5D%20in%20the%20first%20column%20of%20another%20table%20called%20Table_Inventory_Item_Categories%20and%20produce%20the%20corresponding%20value%20in%20column%202%20of%20that%20table.%3CBR%20%2F%3EI%20hope%20this%20helps.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20recommend%20you%20read%20or%20watch%20videos%20about%20Excel%20Tables.%20Knowing%20Excel%20Tables%20and%20taking%20advantage%20of%20them%2C%20allows%20you%20to%20step%20up%20your%20game%20in%20Excel.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-685304%22%20slang%3D%22en-US%22%3ERe%3A%20Version%20of%20Formula%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685304%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FQk7bChbIefg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FQk7bChbIefg%3C%2FA%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

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))),"")

2 Replies
The formula belongs to a table.
When you see @, it means "look at the value in the same row where the formula is, and pick the value under the field between brackets.

There is a table named Table_Inventory_Items
The formula says:
If the value under the field (column) [item_2_category_id] in the same row of the cell containing the formula is "" (empty), then produce "" (empty), otherwise,
If that same value under [item_2_category_id] is equal to the value in cell A5 of sheet 1, then produce "" (empty) as well, otherwise
look for the value in column [item_2_category_id]] in the first column of another table called Table_Inventory_Item_Categories and produce the corresponding value in column 2 of that table.
I hope this helps.

I recommend you read or watch videos about Excel Tables. Knowing Excel Tables and taking advantage of them, allows you to step up your game in Excel.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies