Hi
I am using vlookup() and the table where to look for is in another sheet. I highlighted all the table including labels and named it Mytable1, so my vlookup function looked like this:
Vlookup(A2,Sheet2!Mytable1,2,false)
But to my surprised excel changed Sheet2 to the name of the file, Book1...