Hi I would like to create formulae to automatically update data between worksheets and also between work books. I have attached a copy of the workbook.
I would like to update the prices in service kit contents column H via the part number in column B.
To the part number in numerical column A from the price in column I.
Also is possible to hide columns D to H so they cannot be unhidden when passing the workbook on electronically.
The workbook is 900 rows long.
Thanks in advance
Andy
VLOOKUP should help. Try this in cell H10 of Service Kist-Contents worksheet:Originally Posted by meteor
=VLOOKUP(B10,NUMERICAL!A40:I66,9,FALSE)
Once you get that working, just adapt the formula to suit other lookups. If in doubt, there's plenty of help in Excel for VLOOKUP.
Don't know how to do this, but someone else should be able to help.Also is possible to hide columns D to H so they cannot be unhidden when passing the workbook on electronically.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Hi thanks for the response, the part number is used several times in the workbook so think i need a variable that will look at the whole workbook, but i may be wrong (i am wrong i think, or am i?)
If you fill the formula down the entire column it will look up the same part number and return the same price every time it appears in your list.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks