hai excel forum and all, its not duplicate thread, i asked this question before. But answerd is not working. SO PLEASE DONT CLOSE THIS THREAD., i have a excel. I need to vlookup in another 4 excel files., first lookup in excel 1, if no data there in then transfer lookup in excel 2, and 3, 4 then finally need answerd. if possible give me answered with example excel as u want make yourself.. i want know just 4 vlookup.