Hi,
I'm doing a automated pricelist for our Kitchen showroom, i have a dropdown list to select a doo supplier which in turn enables me to select a style from that supplier from another list and then a list for the colour,
once this is done i input a unit code and that automatically selects the doors for that unit, in then need a vlookup which takes the door size and picks up the price on the suppliers price sheet, range and colour.
Any ideas please as i think this might be beyond me.
Thanks
Posting a sample workbook will lessen the confusion and expedite a solution...
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.
please post a spiffy example
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Customer Invoice and Breakdown test.xlsxPlease see attached Thanks
Change your LOOKUP formulas first to return 0 instead of "" (null), then you can format the cells as Custome, with Type: 0;-0;;@ to hide the 0's.
e.g. in J14 use:
=IF(ISNA(LOOKUP(B14,Sheet2!A:A,Sheet2!G:G)),0,LOOKUP(B14,Sheet2!A:A,Sheet2!G:G))
then in N14 try:
copied down
Please Login or Register to view this content.
Last edited by NBVC; 05-08-2012 at 03:17 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks