Formula Links to another workbook

[srizki]

In one of my worksheet's column there is a link as follows,
=VLOOKUP(E12843,'C:\Documents and Settings\rizki00s\Local Settings\Temp\[Cost Centers names.xls]Sheet1'!$A$1:$B$30,2,FALSE)

and I am trying to open that link, since I did not put that formula, I received this workbook from someone, When I am in that column, I go to Edit- link - open source. and I get a message that this file can not be found, check the spelling ....

what is going on and how can I find the link,

Thanks

 

[Gerald Higgins]

The original file that this link is pointing to is probably on the C drive of the person who sent you the file you have now.

So, you can't easily link to a file on someone else's C drive.
Maybe ask the person who sent you the file to send the other file too, but you'll probably need to edit the links yourself, even if they do send it across.

 

[gbrandreth]

You won't find it, the file its linking to is on somebody elses C: drive. Theyve sent you 1 file but not the other.

You could potentially ask them to send it to you and create a mirrored folder with it in.

Alternatively, when you open it, dont update the links

 

[Gerald Higgins]

Sorry for going off topic, but are you THE gbrandreth ?

http://en.wikipedia.org/wiki/Gyles_Brandreth

 

[srizki]

Thanks to both of you, just one thing is bothering me is that the link has my folder in it,
=VLOOKUP(E12843,'C:\Documents and Settings\rizki00s\Local Settings\Temp\[Cost
Centers names.xls]Sheet1'!$A$1:$B$30,2,FALSE)

Wondering why, does that mean that the file was saved in my temp drive when I opened it and it is no longer there?

I guess that is what it is. Any suggestions?

 

[Gerald Higgins]

No, I think it's guessing that that's where the file must be, because the e-mailed version of the file you have was probably in that directory.

 

[asma410]

Thats because it is looking for a VALUE in the table. It gets confused by alpha-numerics E12843. In the 'Cost Centers name.xls' file you can add a column that has just numbers (say 12843 as a reference for E12843) & search by that reference.

The syntax for the VLookup function is:

VLookup( value, table_array, index_number, not_exact_match )

value is the value to search for in the first column of the table_array.

table_array is two or more columns of data that is sorted in ascending order.

index_number is the column number in table_array from which the matching value must be returned. The first column is 1.

not_exact_match determines if you are looking for an exact match based on value. Enter FALSE to find an exact match. Enter TRUE to find an approximate match, which means that if an exact match if not found, then the VLookup function will look for the next largest value that is less than value.

 

[srizki]

Thank you Gerald and Asma. have a blessed day.