can i use vlookup to seek and retrive data across different sheets in excel?
R Roger Govier Oct 12, 2006 #2 Hi Neil Yes =VLOOKUP(A1,Sheet2!$A$!:$G$100,3,0) If the sheet name has spaces in it then it must be enclosed in single quotes =VLOOKUP(A1,'My Sheet Name'!$A$!:$G$100,3,0)
Hi Neil Yes =VLOOKUP(A1,Sheet2!$A$!:$G$100,3,0) If the sheet name has spaces in it then it must be enclosed in single quotes =VLOOKUP(A1,'My Sheet Name'!$A$!:$G$100,3,0)
