VLOOKUP Table_Array location?

Limio

New Member
Joined
Jul 22, 2010
Messages
1
I have an excel spreadsheet that is baffling me at the moment. It is an order form for a client that is using the VLookup comand. I've been doing research and I understand how to use VLookup, but I'm confused about how this spreadsheet is able to function.

The part that is confusing me is that the Table_array portion is pointing to a location on the C: drive that doesn't exist on my computer or network, and yet the table still functions. How is this possible? The code is looking for another excel table that I don't have. Where is it getting it's table information from?

Example of a line in the table (line 7):

1, RM-140, DI Water, Water, In-house, 57.0900%, 856.350, $0.100, $0.0571

Example of VLookUp code (Column C7):

=VLOOKUP(B7,'C:\MASTER\AC\APOTHECARY LAB\Cary\ApotheCary\Raw Material Pricing Database\[ApotheCary Raw Material List.XLS]Raw Material Price List'!$A$2:$Q$450,2,FALSE)

The excel works fine and I can forward it to other networks, but when I try to cut and paste cells it pops up a browse window asking me to "Update Values: ApotheCary Raw Materials.xls".

It sounds like the table has been cached inside the saved excel sheet? does that mean that there is no way to edit the original data or modify the sheet unless I had the original excel it's looking for? <!-- google_ad_section_end --><!-- EndContentMarker -->

Someone help me wrap my head around this! :confused:

*Notes: There is only one worksheet in this excel file.
Excel 2007
Auto Calculate is set to Automatic
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

rallcorn

Well-known Member
Joined
Nov 11, 2008
Messages
1,027
It is true that you cannot EDIT the original data that was returned by the VLookup since you do not have that data. Even though you're able to see the formula in the formula bar, you really only have the VALUES that the formula returned when the author created the file. When you try to copy the formula you're prompted to access/update the file & you obviously can't lookup the data from the filepath in formula since you don't have access to it.

Search "help" for "edit links" & read-up on this, it will help you understand.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,109
Messages
5,857,438
Members
431,879
Latest member
KiwDaWabbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top