Can anyone help me.
I use a excel 2003 spread sheet at work to track items leaving my department. Now I would like to have excel automatically add a unit price to each of the items, so that I can calculate the amount of loss. I have read that I will have to produce a list of the prices so that excel can search for the data, but how do you get the program to input the data into the next cell on the spreadsheet. I am completely lost
Have a look at Vlookup function in excel help.
e.g
=Vlookup(A1,$X$1:$Y$100,2,False)
this looks up the item found in A1 in X1:X100 and returns what is in corresponding cell in Y1:Y100
adjust references to suit.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Your question raises questions:J
- Do you have a worksheet that includes a list of prices by item number?
- If so, is this list in the same worksheet? The same workbook?
Last edited by jaslake; 06-21-2009 at 09:58 PM. Reason: change terminology
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks