China Naming Network - Almanac query - Formula for naming articles
Formula for naming articles
The table 1 A2 is a cell formula with the name "B2".
=IF(ISERROR(VLLOKUP($A2,Sheet2! $A$2:$B$200,2,0),"",VLLOKUP(A2,Sheet2! $A$2:$B$200,2.0))
Format Handle Drop-down List Copy Formula
Sheet2! $ A $2: $ B $200 is the cell range where the names and corresponding data in Table 2 are located.