refer to a vlookup value

[Guest]

Hi, all , please hel

there is some dataï¼

A B
1 one Tom 3
2 two Jim 60
3 three Andy 9

in that sheet, there is a line like this

total　1　2　3　4　ï¼vlookup(......
(the value of vlookup should be the second line in column C, 60，now it's 60 correctlyã€

Now designate a name to that line, name "total"ï¼

In another file we refer to this line

ï¼'c:\file1'!tota

now, the value should still be 60, but it is 30, the first line of that column, please help

Thank you in advance!

 

[Jonathan Rynd]

Now designate a name to that line, name "total"‹¬O

Could you be a bit more specific -- you are defining a name yes? How do
you define it? What is the range that "total" refers to?