Hi, I have to check unit price in invoice against a price list in another worksheet.
The price list worksheet has the following info
Column a. Model name
Column b Material type
Column c. Size
Column d. Unit price
I want to have a formular in the empty column next to unit price
In the invoice worksheet that would return the price from the
Price list sheet to check if the invoice made by my staff is correct.
Please help.
Last edited by Sali; 10-07-2012 at 11:46 PM. Reason: Solved
im guessin a sumproduct formula or maybe index look up will do the job but without seeing an example its hard to say
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
twiggywales, thank you for reply. I now have attach an example file. Would appreciate your help. thnaks
ok i have doe it for you but you have to remember that the numbers have to be put in precisely the same (as in 3S is not the same as 3-S in the eyes of excel)
(also im not sure your version so i have done a 2003 verson of the formula however if you are in 2007+ then this will work)
entered and then confirmed with CRTL+SHIFT+ENTER (array formula)
Please Login or Register to view this content.
here you go
EXAMPLE INVOICE.xls
i have to do the checking with many invoices so i copy the formula to another worksheet, then i have to change the worksheet name in formula every time.
is there a way to read the name of the worksheet and edit it in the formula automaticly.
I dont know to be honest. i dont think so without a macro
thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks