I want to print the type food based on the index no it has 2,3,4,8 are belongs to fruit Category,there is reference table to save the index value once I type "3" I wanted show fruit
=IF(VLOOKUP(B2,Refernce!A3:A338,1,FALSE),"Fruit",IF(VLOOKUP(JAN!B2,Refernce!B3:B338,1,FALSE),"Vegtable","Drink"))
Aucun commentaire:
Enregistrer un commentaire