i am using Excel 2007 and i didnt find Blookup function , is there any other solution ? macro or function to do the job ? Thanks in advance.