sorry =if(vlookup(a7,'sheet1'A:B,1,false)<>"",vlookup(a7,'sheet1'A:B,1,false),vlookup(a7,'sheet1'A:B,2,false) )