mercredi 16 août 2017

Excel if Function to Identify a Value from a reference column

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