hi thanks for your reply,

through column name "S.No" at sheet "electrical" i can get items info on sheet "daily sheet" but i wont be able to get the same data via column name "location" at sheet "electrical" on sheet "daily sheet"....

i want to find the items via location rather than s.no..... actually it says "#REF" than "#N/A" any idea any help?

file attached...