if u match 2 work sheet u should v lookupie in fist sheet where u want the data in that colum u put formula=vlookup( first colum ,select secoun sheet,2,false) enter