I have an excel spreadsheet that contains a sheet with a list of items with each item assigned a category and value. In that spreadsheet I have another sheet that does uses VLOOKUP formulas to find the associated category and value when I enter the item name.
Is there a way to have the VLOOKUP formula inserted ONLY when I insert a value?
One more question. Is there I way I can export this data into an MS ACCESS database and have the VLOOKUP formula in a query page? At first my sheet works fine, but it is taking longer and longer to calculate, as I now have close to 1400 items. Can the two be linked so that one is updated, the other is updated as well?
THANKS!
This message was edited by Cosmos75 on 2002-04-12 14:50
Is there a way to have the VLOOKUP formula inserted ONLY when I insert a value?
One more question. Is there I way I can export this data into an MS ACCESS database and have the VLOOKUP formula in a query page? At first my sheet works fine, but it is taking longer and longer to calculate, as I now have close to 1400 items. Can the two be linked so that one is updated, the other is updated as well?
THANKS!
This message was edited by Cosmos75 on 2002-04-12 14:50