I have this formula to lookup a value from another sheet
But I would like to exclude some data, for example cell A1, cellA12, cellA22, cell56 or more
IF(C2=Data!$A$1;"None";(LOOKUP(A2;LUV!$F$2:$F$500;LUV!$H$2:$H$500)))
How can I use multiple cells or a Range like A1:A20 in Data criteria instead of Only one Cell. (A1)
Is there another way to right this formula ?:puzzled: