Cell  Formula  I2  =IF($A2="","",VLOOKUP($A2,VL_Data!$A$2:$B$100,2,FALSE))  I3  =IF($A3="","",VLOOKUP($A3,VL_Data!$A$2:$B$100,2,FALSE))  I4  =IF($A4="","",VLOOKUP($A4,VL_Data!$A$2:$B$100,2,FALSE))  I5  =IF($A5="","",VLOOKUP($A5,VL_Data!$A$2:$B$100,2,FALSE))  I6  =IF($A6="","",VLOOKUP($A6,VL_Data!$A$2:$B$100,2,FALSE))  I7  =IF($A7="","",VLOOKUP($A7,VL_Data!$A$2:$B$100,2,FALSE))  I8  =IF($A8="","",VLOOKUP($A8,VL_Data!$A$2:$B$100,2,FALSE))  I9  =IF($A9="","",VLOOKUP($A9,VL_Data!$A$2:$B$100,2,FALSE))  I10  =IF($A10="","",VLOOKUP($A10,VL_Data!$A$2:$B$100,2,FALSE))  I11  =IF($A11="","",VLOOKUP($A11,VL_Data!$A$2:$B$100,2,FALSE))  I12  =IF($A12="","",VLOOKUP($A12,VL_Data!$A$2:$B$100,2,FALSE))  I13  =IF($A13="","",VLOOKUP($A13,VL_Data!$A$2:$B$100,2,FALSE))  I14  =IF($A14="","",VLOOKUP($A14,VL_Data!$A$2:$B$100,2,FALSE))  I15  =IF($A15="","",VLOOKUP($A15,VL_Data!$A$2:$B$100,2,FALSE))  I16  =IF($A16="","",VLOOKUP($A16,VL_Data!$A$2:$B$100,2,FALSE)) 

Like this thread? Share it with others